Backup error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Backup error

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-10-31 : 08:44:37

Gurus,

I am having some problem in back up, at first run evry thing goes fine backup performed but at next timestamp it shows again the same problem
ERROR****Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
10/31/2007 13:00:00,TRANS,Error,0,UUCBTEST,TRANS,(Job outcome),,The job failed. The Job was invoked by Schedule 14 (TRAN). The last step to run was step 1 (TRANS).,00:00:00,0,0,,,,0
10/31/2007 13:00:00,TRANS,Error,1,UUCBTEST,TRANS,TRANS,,Executed as user: NT AUTHORITY\SYSTEM. Database 'UUCB' cannot be opened. It is in the middle of a restore. [SQLSTATE 42000] (Error 927) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.,00:00:00,16,3013,,,,0*********

I cant understand why its throwing the error..?

Can anyone help me..?

Thanks
Krishna

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-10-31 : 10:54:45

It appears a restore operation was interrupted on the UUCB database and it is stuck in the middle of a restore. In SSMS you will probably see that it states (Restoring) next to the database. You should re-initiate and complete a restore to get it back into an operational state.

Future guru in the making.