October 4, 2010 at 2:00 pm
Hello, my backup failed and I don't know why,here is the error message:
Message
Executed as user: NT AUTHORITY\SYSTEM. ... file 1. [SQLSTATE 01000] (Message 4035) Processed 2 pages for database 'master', file 'mastlog' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 362 pages in 0.260 seconds (11.390 MB/sec). [SQLSTATE 01000] (Message 3014) The backup set on file 1 is valid. [SQLSTATE 01000] (Message 3262) Processed 160 pages for database 'model', file 'modeldev' on file 1. [SQLSTATE 01000] (Message 4035) Processed 2 pages for database 'model', file 'modellog' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 162 pages in 0.272 seconds (4.864 MB/sec). [SQLSTATE 01000] (Message 3014) The backup set on file 1 is valid. [SQLSTATE 01000] (Message 3262) Processed 488504 pages for database 'msdb', file 'MSDBData' on file 1. [SQLSTATE 01000] (Message 4035) Processed 72 pages for database 'msdb', file 'MSDBLog' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 488576... The step failed.
Thank you
October 4, 2010 at 2:06 pm
There are no errors in that message. It's cut off, only the first chunk's there.
Check the SQL error log. If a backup failed it'll be logged there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2010 at 3:31 pm
£50 says it's lack of space! Error 112 in the error log
---------------------------------------------------------------------
October 5, 2010 at 12:13 am
Hi
Is it a SSIS package schedule. If so check the step next to MSDBLog backup.
Ali
MCTS SQL Server2k8
October 5, 2010 at 5:57 am
Hello, my backup failed and I don't know why,here is the error message:
As others mentioned it is a truncated error message. Please include a log file to the job step which will have the complete information
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 5, 2010 at 6:04 am
george sibbald (10/4/2010)
Error 112 in the error log
You know, it's sad when we know OS error codes off by heart....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2010 at 7:16 am
GilaMonster (10/5/2010)
george sibbald (10/4/2010)
Error 112 in the error logYou know, it's sad when we know OS error codes off by heart....
I resemble that remark.........
---------------------------------------------------------------------
October 6, 2010 at 3:23 am
george sibbald (10/5/2010)
GilaMonster (10/5/2010)
george sibbald (10/4/2010)
Error 112 in the error logYou know, it's sad when we know OS error codes off by heart....
I resemble that remark.........
Hi
I think there is a disk space problem.i.e. No space to save the backup file.
Ali
MCTS SQL Server2k8
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply