Full back up failed

Question

Post reply

Full back up failed

Krasavita

SSC-Insane

Points: 23138
More actions
October 4, 2010 at 2:00 pm

#239270

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

george sibbald SSC Guru Points: 104210 More actions · Answer 2

£50 says it's lack of space! Error 112 in the error log

---------------------------------------------------------------------

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 3

Hi

Is it a SSIS package schedule. If so check the step next to MSDBLog backup.

Ali
MCTS SQL Server2k8

Adiga One Orange Chip Points: 27284 More actions · Answer 4

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

george sibbald SSC Guru Points: 104210 More actions · Answer 6

GilaMonster (10/5/2010)
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....

I resemble that remark.........

---------------------------------------------------------------------

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 7

george sibbald (10/5/2010)
GilaMonster (10/5/2010)
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....
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