Extracting Sql: backup

Showing posts with label backup. Show all posts

Thursday, March 29, 2012

failed to open. Operating system error = 32(The process cannot access the file because it

BackupDiskFile::OpenMedia: Backup device 'D:\Norahan_db_200502160821.BAK'
failed to open. Operating system error = 32(The process cannot access the
file because it is being used by another process.).what OS backup software do you use? possibility of the backup software
accessing the backup file during sqlserver backup
- open compmgmt.msc and see open sessions to see if the file is in use by
another connection.
- if this does not resolve the issue you might want to check filemon.exe
(setting appropriate filters)
"sql" wrote:
> BackupDiskFile::OpenMedia: Backup device 'D:\Norahan_db_200502160821.BAK'
> failed to open. Operating system error = 32(The process cannot access the
> file because it is being used by another process.).
>
>|||Hi
Check the backup software does not have the file open.
Use handle.exe from the Windows Resource Kit to see what process has the
file in use.
Regards
Mike
"sql" wrote:
> BackupDiskFile::OpenMedia: Backup device 'D:\Norahan_db_200502160821.BAK'
> failed to open. Operating system error = 32(The process cannot access the
> file because it is being used by another process.).
>
>sql

Wednesday, March 21, 2012

Failed services after backup

Last night we did a backup through backup exec using the
no recovery option. This was not part of a plan but it was
done anyway.
This morning when all the databases that had been backed
up with no recovery set were inaccessible (because they
were marked (Loading)) one of the things we did was to
stop to of our SQL server servers.
We now know all we had to do was do a restore database
with recovery but at the time we thought we would stop and
restart the service.
After stopping the service we can not restart it.
it gives a message indicating there was a failure with no
return code.
Does anyone have any ideas on how we can get these servers
started again?
ThanksThe first step is to check the errolog file and see specific messages there.
Then take it from there.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Bob Ryan" <anonymous@.discussions.microsoft.com> wrote in message
news:f32001c3f18c$d1138a20$a001280a@.phx.gbl...
> Last night we did a backup through backup exec using the
> no recovery option. This was not part of a plan but it was
> done anyway.
> This morning when all the databases that had been backed
> up with no recovery set were inaccessible (because they
> were marked (Loading)) one of the things we did was to
> stop to of our SQL server servers.
> We now know all we had to do was do a restore database
> with recovery but at the time we thought we would stop and
> restart the service.
> After stopping the service we can not restart it.
> it gives a message indicating there was a failure with no
> return code.
> Does anyone have any ideas on how we can get these servers
> started again?
>
> Thanks

Failed services after backup

Last night we did a backup through backup exec using the
no recovery option. This was not part of a plan but it was
done anyway.
This morning when all the databases that had been backed
up with no recovery set were inaccessible (because they
were marked (Loading)) one of the things we did was to
stop to of our SQL server servers.
We now know all we had to do was do a restore database
with recovery but at the time we thought we would stop and
restart the service.
After stopping the service we can not restart it.
it gives a message indicating there was a failure with no
return code.
Does anyone have any ideas on how we can get these servers
started again?
ThanksThe first step is to check the errolog file and see specific messages there.
Then take it from there.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Bob Ryan" <anonymous@.discussions.microsoft.com> wrote in message
news:f32001c3f18c$d1138a20$a001280a@.phx.gbl...
> Last night we did a backup through backup exec using the
> no recovery option. This was not part of a plan but it was
> done anyway.
> This morning when all the databases that had been backed
> up with no recovery set were inaccessible (because they
> were marked (Loading)) one of the things we did was to
> stop to of our SQL server servers.
> We now know all we had to do was do a restore database
> with recovery but at the time we thought we would stop and
> restart the service.
> After stopping the service we can not restart it.
> it gives a message indicating there was a failure with no
> return code.
> Does anyone have any ideas on how we can get these servers
> started again?
>
> Thankssql

Failed on runnning maintenance backup plan but....

Hi,
Thank you for your help in advance...
We are running SQL 2K Sp3. For some reason, the maintenance plan (both
backup and optimize) stopped running. I made sure the SQL agent running but
the job never ran successfully. It ran fine before for long time but just
stopped running recently.
I did some tests by setting a maintenanace plan just running a simple db
backup (no transaction log included). it still failed. The error in the
report is " ODBC SQLState:42000" Error 4064...... Cannot open user default
database. Login failed.
However, I setup some backup jobs to backup both db and transaction log by
NOT using maintenance plan. Those work fine.
Do you know what I should look into to fix the problem?
Hope you can help.
Thank you very much for your help.
BobsonHi Bobson,
That should be very easy to fix. Probably the job is running under a user
that has an incorrect default database. Perhaps the default database was
deleted or the user does not have access to it. Change the default database
for this user.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Bobson" wrote:
> Hi,
> Thank you for your help in advance...
> We are running SQL 2K Sp3. For some reason, the maintenance plan (both
> backup and optimize) stopped running. I made sure the SQL agent running but
> the job never ran successfully. It ran fine before for long time but just
> stopped running recently.
> I did some tests by setting a maintenanace plan just running a simple db
> backup (no transaction log included). it still failed. The error in the
> report is " ODBC SQLState:42000" Error 4064...... Cannot open user default
> database. Login failed.
> However, I setup some backup jobs to backup both db and transaction log by
> NOT using maintenance plan. Those work fine.
> Do you know what I should look into to fix the problem?
> Hope you can help.
> Thank you very much for your help.
> Bobson|||Hi Ben,
Thank you very much for your response. After reading your response, I
checked into that but still has no clue.
sa - is default to "master" db. It has full access to it and other dbs.
lsadmin - is the Domain admin account I logged onto the Windows server. It
has full admin right on the local servers and access right to two dbs, ch and
pd.
I tried to run the maintenance jobs on master, ch and pd...but no luck. I
also treid to set up a test maintenance job to backup just the Master db...
but failed as well.
What else should I check ?
Thank you agian for your help.
Bobson
"Ben Nevarez" wrote:
> Hi Bobson,
> That should be very easy to fix. Probably the job is running under a user
> that has an incorrect default database. Perhaps the default database was
> deleted or the user does not have access to it. Change the default database
> for this user.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Bobson" wrote:
> > Hi,
> >
> > Thank you for your help in advance...
> >
> > We are running SQL 2K Sp3. For some reason, the maintenance plan (both
> > backup and optimize) stopped running. I made sure the SQL agent running but
> > the job never ran successfully. It ran fine before for long time but just
> > stopped running recently.
> >
> > I did some tests by setting a maintenanace plan just running a simple db
> > backup (no transaction log included). it still failed. The error in the
> > report is " ODBC SQLState:42000" Error 4064...... Cannot open user default
> > database. Login failed.
> >
> > However, I setup some backup jobs to backup both db and transaction log by
> > NOT using maintenance plan. Those work fine.
> >
> > Do you know what I should look into to fix the problem?
> >
> > Hope you can help.
> >
> > Thank you very much for your help.
> >
> > Bobson|||Try this:
Right-click the job that is not working. Select View Job History, Show step
details. See the steps and look for 'Executed as user: x' or 'The Job was
invoked by User x'. Check the account under which the SQL Server Agent is
running. Also, on SQL Server Agent Properties go to the Connection tab and
see the account used under 'SQL Server connection'.
Then verify that these logins have a valid default database.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Bobson" wrote:
> Hi Ben,
> Thank you very much for your response. After reading your response, I
> checked into that but still has no clue.
> sa - is default to "master" db. It has full access to it and other dbs.
> lsadmin - is the Domain admin account I logged onto the Windows server. It
> has full admin right on the local servers and access right to two dbs, ch and
> pd.
> I tried to run the maintenance jobs on master, ch and pd...but no luck. I
> also treid to set up a test maintenance job to backup just the Master db...
> but failed as well.
> What else should I check ?
> Thank you agian for your help.
> Bobson
>
>
> "Ben Nevarez" wrote:
> >
> > Hi Bobson,
> >
> > That should be very easy to fix. Probably the job is running under a user
> > that has an incorrect default database. Perhaps the default database was
> > deleted or the user does not have access to it. Change the default database
> > for this user.
> >
> > Hope this helps,
> >
> > Ben Nevarez
> > Senior Database Administrator
> > AIG SunAmerica
> >
> >
> >
> > "Bobson" wrote:
> >
> > > Hi,
> > >
> > > Thank you for your help in advance...
> > >
> > > We are running SQL 2K Sp3. For some reason, the maintenance plan (both
> > > backup and optimize) stopped running. I made sure the SQL agent running but
> > > the job never ran successfully. It ran fine before for long time but just
> > > stopped running recently.
> > >
> > > I did some tests by setting a maintenanace plan just running a simple db
> > > backup (no transaction log included). it still failed. The error in the
> > > report is " ODBC SQLState:42000" Error 4064...... Cannot open user default
> > > database. Login failed.
> > >
> > > However, I setup some backup jobs to backup both db and transaction log by
> > > NOT using maintenance plan. Those work fine.
> > >
> > > Do you know what I should look into to fix the problem?
> > >
> > > Hope you can help.
> > >
> > > Thank you very much for your help.
> > >
> > > Bobson|||Hi Ben,
Good morning. Thank you for your response again!
I just checked it...in the Connection tab. It was pointing to Windows
Authenticaitons...so I change it to use SA account instead. And tried to run
the job again. It works!!
Again, thank you very much for your help. Happy holidays to you and your
family!!
Bobson
"Ben Nevarez" wrote:
> Try this:
> Right-click the job that is not working. Select View Job History, Show step
> details. See the steps and look for 'Executed as user: x' or 'The Job was
> invoked by User x'. Check the account under which the SQL Server Agent is
> running. Also, on SQL Server Agent Properties go to the Connection tab and
> see the account used under 'SQL Server connection'.
> Then verify that these logins have a valid default database.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Bobson" wrote:
> > Hi Ben,
> >
> > Thank you very much for your response. After reading your response, I
> > checked into that but still has no clue.
> >
> > sa - is default to "master" db. It has full access to it and other dbs.
> > lsadmin - is the Domain admin account I logged onto the Windows server. It
> > has full admin right on the local servers and access right to two dbs, ch and
> > pd.
> >
> > I tried to run the maintenance jobs on master, ch and pd...but no luck. I
> > also treid to set up a test maintenance job to backup just the Master db...
> > but failed as well.
> >
> > What else should I check ?
> >
> > Thank you agian for your help.
> >
> > Bobson
> >
> >
> >
> >
> > "Ben Nevarez" wrote:
> >
> > >
> > > Hi Bobson,
> > >
> > > That should be very easy to fix. Probably the job is running under a user
> > > that has an incorrect default database. Perhaps the default database was
> > > deleted or the user does not have access to it. Change the default database
> > > for this user.
> > >
> > > Hope this helps,
> > >
> > > Ben Nevarez
> > > Senior Database Administrator
> > > AIG SunAmerica
> > >
> > >
> > >
> > > "Bobson" wrote:
> > >
> > > > Hi,
> > > >
> > > > Thank you for your help in advance...
> > > >
> > > > We are running SQL 2K Sp3. For some reason, the maintenance plan (both
> > > > backup and optimize) stopped running. I made sure the SQL agent running but
> > > > the job never ran successfully. It ran fine before for long time but just
> > > > stopped running recently.
> > > >
> > > > I did some tests by setting a maintenanace plan just running a simple db
> > > > backup (no transaction log included). it still failed. The error in the
> > > > report is " ODBC SQLState:42000" Error 4064...... Cannot open user default
> > > > database. Login failed.
> > > >
> > > > However, I setup some backup jobs to backup both db and transaction log by
> > > > NOT using maintenance plan. Those work fine.
> > > >
> > > > Do you know what I should look into to fix the problem?
> > > >
> > > > Hope you can help.
> > > >
> > > > Thank you very much for your help.
> > > >
> > > > Bobson|||Hi Bobson,
I am glad you fixed the problem.
Happy holidays!
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Bobson" wrote:
> Hi Ben,
> Good morning. Thank you for your response again!
> I just checked it...in the Connection tab. It was pointing to Windows
> Authenticaitons...so I change it to use SA account instead. And tried to run
> the job again. It works!!
> Again, thank you very much for your help. Happy holidays to you and your
> family!!
> Bobson
> "Ben Nevarez" wrote:
> >
> > Try this:
> >
> > Right-click the job that is not working. Select View Job History, Show step
> > details. See the steps and look for 'Executed as user: x' or 'The Job was
> > invoked by User x'. Check the account under which the SQL Server Agent is
> > running. Also, on SQL Server Agent Properties go to the Connection tab and
> > see the account used under 'SQL Server connection'.
> >
> > Then verify that these logins have a valid default database.
> >
> > Hope this helps,
> >
> > Ben Nevarez
> > Senior Database Administrator
> > AIG SunAmerica
> >
> >
> >
> > "Bobson" wrote:
> >
> > > Hi Ben,
> > >
> > > Thank you very much for your response. After reading your response, I
> > > checked into that but still has no clue.
> > >
> > > sa - is default to "master" db. It has full access to it and other dbs.
> > > lsadmin - is the Domain admin account I logged onto the Windows server. It
> > > has full admin right on the local servers and access right to two dbs, ch and
> > > pd.
> > >
> > > I tried to run the maintenance jobs on master, ch and pd...but no luck. I
> > > also treid to set up a test maintenance job to backup just the Master db...
> > > but failed as well.
> > >
> > > What else should I check ?
> > >
> > > Thank you agian for your help.
> > >
> > > Bobson
> > >
> > >
> > >
> > >
> > > "Ben Nevarez" wrote:
> > >
> > > >
> > > > Hi Bobson,
> > > >
> > > > That should be very easy to fix. Probably the job is running under a user
> > > > that has an incorrect default database. Perhaps the default database was
> > > > deleted or the user does not have access to it. Change the default database
> > > > for this user.
> > > >
> > > > Hope this helps,
> > > >
> > > > Ben Nevarez
> > > > Senior Database Administrator
> > > > AIG SunAmerica
> > > >
> > > >
> > > >
> > > > "Bobson" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > Thank you for your help in advance...
> > > > >
> > > > > We are running SQL 2K Sp3. For some reason, the maintenance plan (both
> > > > > backup and optimize) stopped running. I made sure the SQL agent running but
> > > > > the job never ran successfully. It ran fine before for long time but just
> > > > > stopped running recently.
> > > > >
> > > > > I did some tests by setting a maintenanace plan just running a simple db
> > > > > backup (no transaction log included). it still failed. The error in the
> > > > > report is " ODBC SQLState:42000" Error 4064...... Cannot open user default
> > > > > database. Login failed.
> > > > >
> > > > > However, I setup some backup jobs to backup both db and transaction log by
> > > > > NOT using maintenance plan. Those work fine.
> > > > >
> > > > > Do you know what I should look into to fix the problem?
> > > > >
> > > > > Hope you can help.
> > > > >
> > > > > Thank you very much for your help.
> > > > >
> > > > > Bobson

Failed on runnning maintenance backup plan but....

Monday, March 19, 2012

Failed Maintenance Plan

Please advice.
I run a SQL2k SP4 on WIN2K SP4.
I have a maintenance plan to backup the databases at 01:30AM. This has alway
s been succesfull.
Strangely it did the backup at 02:25PM with no entry in SQL Error Log and ca
using subsequent backups to fail as the files created had the 02:25 badge he
nce could not be deleted.
Please help as to what caused the maintenance plan to backup at 02:25 and wh
at to do to avoid it.
Thanks for your kind response.I posted a reply to this yesterday. Here's that text:
My guess is that it wasn't Main Plan that did the backup, someone else did i
t (or explicitly started the main
plan job, or scheduled the main plan job at that hour). If it was executed a
s a job, you can view the job
history under EM, Management, Jobs. In any event, each backup is written to
the eventlog and the errorlog
file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Timi" <anonymous@.discussions.microsoft.com> wrote in message
news:EA0A7329-EAA1-49B3-9DDB-1736B6F35A4C@.microsoft.com...
> Please advice.
> I run a SQL2k SP4 on WIN2K SP4.
> I have a maintenance plan to backup the databases at 01:30AM. This has alw
ays been succesfull.
> Strangely it did the backup at 02:25PM with no entry in SQL Error Log and causing
subsequent backups to fail
as the files created had the 02:25 badge hence could not be deleted.
> Please help as to what caused the maintenance plan to backup at 02:25 and
what to do to avoid it.
> Thanks for your kind response.
>|||Thanks for your response.
The maint plan was ran at 02:25AM as opposed to 01:30AM the scheduled time.|||can you check with your server guys if there was a problem
with the server which resulted in it being restarted on or
arounf 2:25 ?, but the best way of finding out is to check
the error log.
J

>--Original Message--
>Thanks for your response.
>The maint plan was ran at 02:25AM as opposed to 01:30AM
the scheduled time.
>.
>|||Agent does no run a job if it was down at the time it should have executed.
I doubt that this is the reason,
based on that. I bet a beer that someone started the job at that time.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Julie" <anonymous@.discussions.microsoft.com> wrote in message news:13fdd01c41357$84085e80$
a301280a@.phx.gbl...
> can you check with your server guys if there was a problem
> with the server which resulted in it being restarted on or
> arounf 2:25 ?, but the best way of finding out is to check
> the error log.
> J
>
> the scheduled time.|||Bet a beer against you and your SQL Server knowledge, never ;)
Anyway your right but my sneaky plan was to get Timm to check the server, as
we both agree thats where the problem is, and who actually started it.|||:-)
<<as we both agree thats where the problem is, and who actually started it.>
>
Yep.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:D6CB3367-9F9F-4633-B7FE-3FBEBFFA8B74@.microsoft.com...
> Bet a beer against you and your SQL Server knowledge, never ;)
> Anyway your right but my sneaky plan was to get Timm to check the server, as we bo
th agree thats where the
problem is, and who actually started it.

Failed Maintenance Plan

Please advice.
I run a SQL2k SP4 on WIN2K SP4.
I have a maintenance plan to backup the databases at 01:30AM. This has alway
s been successfull.
Strangely it did the backup at 02:25PM with no entry in SQL Error Log and ca
using subsequent backups to fail as the files created had the 02:25 badge he
nce could not be deleted.
Please help as to what caused the maintenece plan to backup at 02:25 and wha
t to do to avoid it.
Thanks for your kind response.My guess is that it wasn't Main Plan that did the backup, someone else did i
t (or explicitly started the main
plan job, or scheduled the main plan job at that hour). If it was executed a
s a job, you can view the job
history under EM, Management, Jobs. In any event, each backup is written to
the eventlog and the errorlog
file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Timi" <anonymous@.discussions.microsoft.com> wrote in message
news:CDA33615-5054-47D3-8D06-0A52B8FB7544@.microsoft.com...
> Please advice.
> I run a SQL2k SP4 on WIN2K SP4.
> I have a maintenance plan to backup the databases at 01:30AM. This has alw
ays been successfull.
> Strangely it did the backup at 02:25PM with no entry in SQL Error Log and causing
subsequent backups to fail
as the files created had the 02:25 badge hence could not be deleted.
> Please help as to what caused the maintenece plan to backup at 02:25 and w
hat to do to avoid it.
> Thanks for your kind response.
>

Monday, March 12, 2012

Failed Backup Error Message SQL 2000

I continually receive the following error when trying to backup the one
database.
3041 :
BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK = N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
--
www.synecology.comIf you check the SQL server error log you should see a message just before
this one that should have some further detail on why it is failing. If you
run it through QA do you get additional error messages ?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>I continually receive the following error when trying to backup the one
> database.
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK => N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT ,
> NOUNLOAD
> , NOSKIP , STATS = 10, NOFORMAT
> --
> www.synecology.com|||Here is the previous error message:
SPID 55
Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
m_actualBytes: 0, m_errcode: 112, BackupFile:
L:\SQLDatabaseBackups\Data_db_200501090201.BAK
There was a space issue, but that has been resolved.
"Jasper Smith" wrote:
> If you check the SQL server error log you should see a message just before
> this one that should have some further detail on why it is failing. If you
> run it through QA do you get additional error messages ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
> >I continually receive the following error when trying to backup the one
> > database.
> >
> > 3041 :
> > BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK => > N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT ,
> > NOUNLOAD
> > , NOSKIP , STATS = 10, NOFORMAT
> > --
> > www.synecology.com
>
>|||And you see the same errors when running it through Query Analyzer? Is it
possible to try writing the backup to a different drive just to see if that
has any effect?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...
> Here is the previous error message:
> SPID 55
> Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
> 983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
> Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
> m_actualBytes: 0, m_errcode: 112, BackupFile:
> L:\SQLDatabaseBackups\Data_db_200501090201.BAK
> There was a space issue, but that has been resolved.
> "Jasper Smith" wrote:
>> If you check the SQL server error log you should see a message just
>> before
>> this one that should have some further detail on why it is failing. If
>> you
>> run it through QA do you get additional error messages ?
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
>> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>> >I continually receive the following error when trying to backup the one
>> > database.
>> >
>> > 3041 :
>> > BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK =>> > N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT ,
>> > NOUNLOAD
>> > , NOSKIP , STATS = 10, NOFORMAT
>> > --
>> > www.synecology.com
>>|||I just ran the backup after cleaning up the 2 drives that had space issues.
and received no errors.
Is it possible that the failed backup could change the database to single
user mode?
"Jasper Smith" wrote:
> And you see the same errors when running it through Query Analyzer? Is it
> possible to try writing the backup to a different drive just to see if that
> has any effect?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...
> > Here is the previous error message:
> > SPID 55
> > Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
> > 983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
> > Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
> > m_actualBytes: 0, m_errcode: 112, BackupFile:
> > L:\SQLDatabaseBackups\Data_db_200501090201.BAK
> >
> > There was a space issue, but that has been resolved.
> >
> > "Jasper Smith" wrote:
> >
> >> If you check the SQL server error log you should see a message just
> >> before
> >> this one that should have some further detail on why it is failing. If
> >> you
> >> run it through QA do you get additional error messages ?
> >>
> >> --
> >> HTH
> >>
> >> Jasper Smith (SQL Server MVP)
> >> http://www.sqldbatips.com
> >> I support PASS - the definitive, global
> >> community for SQL Server professionals -
> >> http://www.sqlpass.org
> >>
> >> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> >> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
> >> >I continually receive the following error when trying to backup the one
> >> > database.
> >> >
> >> > 3041 :
> >> > BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK => >> > N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT ,
> >> > NOUNLOAD
> >> > , NOSKIP , STATS = 10, NOFORMAT
> >> > --
> >> > www.synecology.com
> >>
> >>
> >>
>
>|||A backup failure should have no effect on the recovery model of the
database. However, maintenance plans did in the past have a habit of leaving
databases in single user mode if you had the "Attempt to repair minor
problems" option selected although I believe this should be fixed by now in
one of the service packs
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:A03F1658-EDFF-4DE3-8653-65AAE6EEF38B@.microsoft.com...
>I just ran the backup after cleaning up the 2 drives that had space issues.
> and received no errors.
> Is it possible that the failed backup could change the database to single
> user mode?
>
> "Jasper Smith" wrote:
>> And you see the same errors when running it through Query Analyzer? Is it
>> possible to try writing the backup to a different drive just to see if
>> that
>> has any effect?
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
>> news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...
>> > Here is the previous error message:
>> > SPID 55
>> > Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
>> > 983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
>> > Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
>> > m_actualBytes: 0, m_errcode: 112, BackupFile:
>> > L:\SQLDatabaseBackups\Data_db_200501090201.BAK
>> >
>> > There was a space issue, but that has been resolved.
>> >
>> > "Jasper Smith" wrote:
>> >
>> >> If you check the SQL server error log you should see a message just
>> >> before
>> >> this one that should have some further detail on why it is failing. If
>> >> you
>> >> run it through QA do you get additional error messages ?
>> >>
>> >> --
>> >> HTH
>> >>
>> >> Jasper Smith (SQL Server MVP)
>> >> http://www.sqldbatips.com
>> >> I support PASS - the definitive, global
>> >> community for SQL Server professionals -
>> >> http://www.sqlpass.org
>> >>
>> >> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
>> >> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>> >> >I continually receive the following error when trying to backup the
>> >> >one
>> >> > database.
>> >> >
>> >> > 3041 :
>> >> > BACKUP failed to complete the command BACKUP DATABASE [Data] TO
>> >> > DISK =>> >> > N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT ,
>> >> > NOUNLOAD
>> >> > , NOSKIP , STATS = 10, NOFORMAT
>> >> > --
>> >> > www.synecology.com
>> >>
>> >>
>> >>
>>

Failed Backup Error Message SQL 2000

failed backup

what can I look at to determine why a backup failed. I have a maintence pla
n that does a full backup once a week and another plan that will do a transa
ction log backup every day at 1am. The full backups are running fine. The
daily backup of the trans l
og fails everyday. The SQL Server log does not mention the failed backup.
The History of the job does say failed but gives no reason. The Server (box
) has an entry in the Application Log but it is not much better; it just say
s failed. What can I do to
troubleshoot this?Is your database in Simple recovery mode? You can't back up the
transactionlog in simple recovery mode, only in Bulk Logged or Full recovery
mode.
Jacco Schalkwijk
SQL Server MVP
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:8354B199-B0F2-4FFD-919B-17841BB1EF66@.microsoft.com...
> what can I look at to determine why a backup failed. I have a maintence
plan that does a full backup once a week and another plan that will do a
transaction log backup every day at 1am. The full backups are running fine.
The daily backup of the trans log fails everyday. The SQL Server log does
not mention the failed backup. The History of the job does say failed but
gives no reason. The Server (box) has an entry in the Application Log but
it is not much better; it just says failed. What can I do to troubleshoot
this?|||Outstanding Jacco! Two out of the fourteen databases I was trying to backup
the transaction log on were set to "simple". Those happen to be the two I
did not make! Thanks for the tip!|||Another thing you can do for the future is go to the Scheduled Task itself,
Go to Steps and edit the Step, Go to Advanced and set an output file. This
way you can always look at the file to see why something failed.
Jeff Duncan
MCDBA, MCSE+I

failed backup

what can I look at to determine why a backup failed. I have a maintence plan that does a full backup once a week and another plan that will do a transaction log backup every day at 1am. The full backups are running fine. The daily backup of the trans l
og fails everyday. The SQL Server log does not mention the failed backup. The History of the job does say failed but gives no reason. The Server (box) has an entry in the Application Log but it is not much better; it just says failed. What can I do to
troubleshoot this?
Is your database in Simple recovery mode? You can't back up the
transactionlog in simple recovery mode, only in Bulk Logged or Full recovery
mode.
Jacco Schalkwijk
SQL Server MVP
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:8354B199-B0F2-4FFD-919B-17841BB1EF66@.microsoft.com...
> what can I look at to determine why a backup failed. I have a maintence
plan that does a full backup once a week and another plan that will do a
transaction log backup every day at 1am. The full backups are running fine.
The daily backup of the trans log fails everyday. The SQL Server log does
not mention the failed backup. The History of the job does say failed but
gives no reason. The Server (box) has an entry in the Application Log but
it is not much better; it just says failed. What can I do to troubleshoot
this?
|||Outstanding Jacco! Two out of the fourteen databases I was trying to backup the transaction log on were set to "simple". Those happen to be the two I did not make! Thanks for the tip!
|||Another thing you can do for the future is go to the Scheduled Task itself, Go to Steps and edit the Step, Go to Advanced and set an output file. This way you can always look at the file to see why something failed.
Jeff Duncan
MCDBA, MCSE+I

Sunday, February 19, 2012

Extracting RDL file from published reports in RS 2000

In order to have a backup of the rdl files for reporting, does exist a manner
to extract the rdl files inside RS starting from published reports?
In other terms, is it possible to revert the report publishing process in
order to have the rdl files?
Many thanksOn Sep 11, 3:44 am, Pasquale <Pasqu...@.discussions.microsoft.com>
wrote:
> In order to have a backup of the rdl files for reporting, does exist a manner
> to extract the rdl files inside RS starting from published reports?
> In other terms, is it possible to revert the report publishing process in
> order to have the rdl files?
> Many thanks
Try this application, works great for me. http://sqldbatips.com/showarticle.asp?ID=62|||Oh, well! It's very useful.
Many thanks
"Tim Toennies" wrote:
> On Sep 11, 3:44 am, Pasquale <Pasqu...@.discussions.microsoft.com>
> wrote:
> > In order to have a backup of the rdl files for reporting, does exist a manner
> > to extract the rdl files inside RS starting from published reports?
> > In other terms, is it possible to revert the report publishing process in
> > order to have the rdl files?
> > Many thanks
> Try this application, works great for me. http://sqldbatips.com/showarticle.asp?ID=62
>

Friday, February 17, 2012

Extracting a table from a dbbackup possible?

Hi there,
A poweruser dropped a table in production(don't ask me why he got
authorization to do that!). So I would restore the backup to a new,
temporary db to extract this table. However, the server lacks diskspace
for another 28 Gb db. This will be remedied in the near future, but
right now I have no room to restore this backup. Is there a way to
extract just 1 table from a backupdevice? I could not find anything via
google sofar, so I doubt it; still, anyone has a solution?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!There is no way to extract a single table from a backup. You must restore
the backup first. I am afraid you will need to find the space somewhere to
restore to.
--
Andrew J. Kelly SQL MVP
"hansje" <hansjes@.anonymous.com> wrote in message
news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> A poweruser dropped a table in production(don't ask me why he got
> authorization to do that!). So I would restore the backup to a new,
> temporary db to extract this table. However, the server lacks diskspace
> for another 28 Gb db. This will be remedied in the near future, but
> right now I have no room to restore this backup. Is there a way to
> extract just 1 table from a backupdevice? I could not find anything via
> google sofar, so I doubt it; still, anyone has a solution?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Lumigent Log Explorer can help with this if you have the logs of when the
table was dropped.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"hansje" <hansjes@.anonymous.com> wrote in message
news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> A poweruser dropped a table in production(don't ask me why he got
> authorization to do that!). So I would restore the backup to a new,
> temporary db to extract this table. However, the server lacks diskspace
> for another 28 Gb db. This will be remedied in the near future, but
> right now I have no room to restore this backup. Is there a way to
> extract just 1 table from a backupdevice? I could not find anything via
> google sofar, so I doubt it; still, anyone has a solution?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Good point Ray...
--
Andrew J. Kelly SQL MVP
"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:ObdQdfPtDHA.2932@.TK2MSFTNGP11.phx.gbl...
> Lumigent Log Explorer can help with this if you have the logs of when the
> table was dropped.
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "hansje" <hansjes@.anonymous.com> wrote in message
> news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> > Hi there,
> >
> > A poweruser dropped a table in production(don't ask me why he got
> > authorization to do that!). So I would restore the backup to a new,
> > temporary db to extract this table. However, the server lacks diskspace
> > for another 28 Gb db. This will be remedied in the near future, but
> > right now I have no room to restore this backup. Is there a way to
> > extract just 1 table from a backupdevice? I could not find anything via
> > google sofar, so I doubt it; still, anyone has a solution?
> >
> > Tnx,
> >
> > Hans Brouwer
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>|||Yep!, there were problems with undoing DDL commands in regards to tables in
Log Explorer but the latest version is supposed to have fixed that.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:%23lUiIkPtDHA.424@.TK2MSFTNGP11.phx.gbl...
> Good point Ray...
> --
> Andrew J. Kelly SQL MVP
>
> "Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
> news:ObdQdfPtDHA.2932@.TK2MSFTNGP11.phx.gbl...
> > Lumigent Log Explorer can help with this if you have the logs of when
the
> > table was dropped.
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "hansje" <hansjes@.anonymous.com> wrote in message
> > news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> > > Hi there,
> > >
> > > A poweruser dropped a table in production(don't ask me why he got
> > > authorization to do that!). So I would restore the backup to a new,
> > > temporary db to extract this table. However, the server lacks
diskspace
> > > for another 28 Gb db. This will be remedied in the near future, but
> > > right now I have no room to restore this backup. Is there a way to
> > > extract just 1 table from a backupdevice? I could not find anything
via
> > > google sofar, so I doubt it; still, anyone has a solution?
> > >
> > > Tnx,
> > >
> > > Hans Brouwer
> > >
> > > *** Sent via Developersdex http://www.developersdex.com ***
> > > Don't just participate in USENET...get rewarded for it!
> >
> >
>

Thursday, March 29, 2012

failed to open. Operating system error = 32(The process cannot access the file because it

Wednesday, March 21, 2012

Failed services after backup

Failed services after backup

Failed on runnning maintenance backup plan but....

Failed on runnning maintenance backup plan but....

Failed on runnning maintenance backup plan but....

Monday, March 19, 2012

Failed Maintenance Plan

Failed Maintenance Plan

Monday, March 12, 2012

Failed Backup Error Message SQL 2000

Failed Backup Error Message SQL 2000

Failed Backup Error Message SQL 2000

failed backup

failed backup

Sunday, February 19, 2012

Extracting RDL file from published reports in RS 2000

Friday, February 17, 2012

Extracting a table from a dbbackup possible?

Extracting Sql

Blog Archive

About Me