|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Backup FailureI've encountered an error while performing a database backup. I can't seem to
find this error anywhere: BACKUP failed to complete the command master.dbo.sp_sqlexec;1 Does anyone have any insight into this error? Thank You! How do you execute the backup? For troubleshooting purposes, try executing a BACKUP command from
Query analyzer. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "A. Robinson" <ARobin***@discussions.microsoft.com> wrote in message news:6DCC9B4B-4EE8-428A-842B-7E191FFE5AB6@microsoft.com... > I've encountered an error while performing a database backup. I can't seem to > find this error anywhere: > > BACKUP failed to complete the command master.dbo.sp_sqlexec;1 > > Does anyone have any insight into this error? > > Thank You! The backup is executed as a scheduled job. This job has been running for
months without any issues - then suddenly... When run manually, works just fine... Show quoteHide quote "Tibor Karaszi" wrote: > How do you execute the backup? For troubleshooting purposes, try executing a BACKUP command from > Query analyzer. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > Blog: http://solidqualitylearning.com/blogs/tibor/ > > > "A. Robinson" <ARobin***@discussions.microsoft.com> wrote in message > news:6DCC9B4B-4EE8-428A-842B-7E191FFE5AB6@microsoft.com... > > I've encountered an error while performing a database backup. I can't seem to > > find this error anywhere: > > > > BACKUP failed to complete the command master.dbo.sp_sqlexec;1 > > > > Does anyone have any insight into this error? > > > > Thank You! > > Is it a TSQL job? How many jobsteps does the job contain? Where did you get the error message from?
The job output of a job step in the job? If you are uncertain, define a different output file for each jobstep and see exactly which jobstep this message is from. Then post the TSQL commands you have in that jobstep. I'm asking because the error you posted doesn't look like an error that the BACKUP command would produce. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "A. Robinson" <ARobin***@discussions.microsoft.com> wrote in message news:D2BB3DBC-BFC5-4581-877B-6BE65F7E0E23@microsoft.com... > The backup is executed as a scheduled job. This job has been running for > months without any issues - then suddenly... > > When run manually, works just fine... > > "Tibor Karaszi" wrote: > >> How do you execute the backup? For troubleshooting purposes, try executing a BACKUP command from >> Query analyzer. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> Blog: http://solidqualitylearning.com/blogs/tibor/ >> >> >> "A. Robinson" <ARobin***@discussions.microsoft.com> wrote in message >> news:6DCC9B4B-4EE8-428A-842B-7E191FFE5AB6@microsoft.com... >> > I've encountered an error while performing a database backup. I can't seem to >> > find this error anywhere: >> > >> > BACKUP failed to complete the command master.dbo.sp_sqlexec;1 >> > >> > Does anyone have any insight into this error? >> > >> > Thank You! >> >>  
Thread options
Other interesting topics
HAVING vs. WHERE
Sort Help Searched Column w/Case for column name: Invalid column name 'TACD' LOCK & SELECT Behavior DTS problem Need help with the sequel statement please. Cannot get to work a sentence with NULL results Help with Case Statement [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID X) was deadlocked How to detect INSTALLED SQL version? |
|||||||||||||||||||||||
