Scheduled database Backup...

[Grant007]

Hi guys,

I put my test db on a scheduled backup. It stats the it is 100 percent backed up.

i then get this error message:

[SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'test',
file 'test_log' on file 1. [SQLSTATE 01000] (Message 4035)
BACKUP DATABASE is terminating abnormall... The step failed.

any ideas why after backing up 100% it then terminates abnormally.. and the job fails?

any suggestions would be gretfully received...

thanks

 

[JayKusch]

Check to see if the database is in Simple mode. Open Enterprise Manager and drill down to your Test DB. Right-click on the Test DB and choose Properties. In the Options tab, you will see what the current Recovery Mode is set to. 10 to 1 it is Simple. Change it to FULL and try your backup job again.

Thanks

J. Kusch

 

[Grant007]

no db is not in simple mode it is in full mode.. does transaction logs fine but just wont do a full backup...

any other suggestions would be greatfully received...

 

[SimonTheSponge]

Grant could you post the full text of the backup step that is running in your schedule.

Have you tried backing up the database manually through Enterprise Manager ?

 

[SQLBill]

What are you backing up to? Is the location getting full?

Are you doing this backup via a job? If so, right click on the job, select View Job History..., check the box for Show step details. Is there anything that would give a further explanation of the error?

Also, check the Windows Event Viewer Logs to see if there are any related error messages beside the one you posted.

-SQLBill

Posting advice: FAQ481-4875

 

[Grant007]

this is what is in the backup job...


BACKUP DATABASE [test] TO DISK = N'\\192.168.1.2\sqlbackups\sql\bak\test\test.bak' WITH INIT , NOUNLOAD , NAME = N'test backup', NOSKIP , STATS = 10, NOFORMAT

i have tried manual backup and the same thing happens it gets to 100% then quites abnormally....

here is the exact error from job history...

Executed as user: CRIPPS\test$. ... 20 percent backed up. [SQLSTATE 01000] (Message 3211) 30 percent backed up. [SQLSTATE 01000] (Message 3211) 40 percent backed up. [SQLSTATE 01000] (Message 3211) 50 percent backed up. [SQLSTATE 01000] (Message 3211) 60 percent backed up. [SQLSTATE 01000] (Message 3211) 70 percent backed up. [SQLSTATE 01000] (Message 3211) 80 percent backed up. [SQLSTATE 01000] (Message 3211) 90 percent backed up. [SQLSTATE 01000] (Message 3211) Processed 584 pages for database 'test', file 'test_sys' on file 1. [SQLSTATE 01000] (Message 4035) Processed 72880 pages for database 'test', file 'test_DATA01' on file 1. [SQLSTATE 01000] (Message 4035) Processed 51832 pages for database 'test', file 'test_INDEX01' on file 1. [SQLSTATE 01000] (Message 4035) 100 percent backed up. [SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'test', file 'test_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE is terminating abnormall... The step failed.