Error during Backup - 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

General SQL Server Forums

New to SQL Server Programming

Error during Backup

Author

Topic

nishi57
Starting Member

20 Posts

Posted - 2007-09-12 : 10:28:39

Here is my situation, I am backing up two databases on a periodic basis, however one database gets backed up without any issues, the other database gives me the following error message. I have done quite a lot of research, but have not found a solution to this problem. Here is the error thats being generated -

"BACKUP failed to complete the command BACKUP LOG [R1MaxCRM] TO DISK = N'D:\SQL Backups\R1MaxCRM\R1MaxCRM_tlog_200709120000.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"

Can someone point me in the right direction.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-12 : 12:53:30

Have you tried running the command in Query Analyzer or Management Studio to see if it succeeds?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Kristen
Test

22859 Posts

Posted - 2007-09-12 : 14:12:02

I'm always curios to know how tape-specific-commands creep into a disk-backup command

nishi57
Starting Member

20 Posts

Posted - 2007-09-12 : 14:15:17

Yes I have tried that in the past, however I get the following message -

Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'to'.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-12 : 14:24:29