none
BACKUP failed to complete the command BACKUP DATABASE *****

    Question

  • This is the error message:

    02/22/2010 15:40:31,Backup,Unknown,BACKUP failed to complete the command BACKUP DATABASE Hist_OHLC_Ameritrade. Check the backup application log for detailed messages.

    I don't have a log in my application unless it is somehow generated spontaneously by the OS. The error message is 3041 which is 3041   16   BACKUP failed to complete the command %.*ls

    Go figure.
    AlexB - Win_7 Pro64, SqlSer64 WinSer64
    Tuesday, February 23, 2010 1:51 AM

Answers

  • My experience is that we in the errorlog also would find the reason for the backup command to fail. Before or after this message. Without that reason, it is very difficult to comment, I'm afraid.
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    Wednesday, February 24, 2010 5:53 PM
    Moderator

All replies

  • How have you invoked that command, via Sql Job, by executing it directly in Sql Server Management Studio. Have you checked ERRORLOG or Sql Server Log ?

    Have you checked Windows Application / System Log (maybe the issues was in your system)

    With kind regards
    Krystian Zieja
    http://www.projectenvision.com
    Tuesday, February 23, 2010 2:58 AM
  • Check for the sufficient disk space once the Backup command is OK.
    Tuesday, February 23, 2010 9:07 AM
  • How have you invoked that command, via Sql Job, by executing it directly in Sql Server Management Studio. Have you checked ERRORLOG or Sql Server Log ?

    Have you checked Windows Application / System Log (maybe the issues was in your system)

    With kind regards
    Krystian Zieja
    http://www.projectenvision.com

    Krystian, I ran the command from my C# .NET application. The SP is thrid-party, freeware, here is the link. It is a downlodable zip and if you want I can post the whole SP. I checked the Sql Server LOg for yesterday where I found complete account of backup including the fact that about 16 databases were saved but it failed on the 17th or so with some 10 dbs left.

    I did not check Windows Application / System Log. I will have to find out how to get hold of it. What do you mean by that? Where is that log? Where is the folder?

    I tried to search System Log in my system and found a few Xml error files but nothing for yesterday.

    Thanks.
    AlexB - Win_7 Pro64, SqlSer64 WinSer64
    Tuesday, February 23, 2010 4:57 PM
  • I would suggest trying to perform backup using Sql Server Managemetn Studio, using backup database dbname to disk = 'C:\backups\mybackup.bak'

    To perform backup from C# application I would strongly recomment using SMO componenet. You can find details and examples on MSDN sites.

    I do now know your operating system version but below procedure should work:
    Click Start, then right click Computer and select manage | then depending on your OS, you will see Diagnostics or Event Logs below that node you will see Application and System Logs

    With kind regards
    Krystian Zieja
    http://www.projectenvision.com
    Tuesday, February 23, 2010 7:03 PM
  • Krystian hi,

    Smo is my preferred way to handle Sql Server probklems. I do have a code, actually a few procedures. The problem is I was unable to do one simple thing: to create the backup file with Smo initially. After I did the first backup I can continue with Smo. If you are familiar with Smo I can post my routine and you will look into it.

    There is a wider issue here, however. I want to have many options abailable, this is why I a pursuing SP backup.

    Thanks.
    AlexB - Win_7 Pro64, SqlSer64 WinSer64
    Tuesday, February 23, 2010 7:55 PM
  • I checked Event Log and could not find anything that seemed to be relevant.
    AlexB - Win_7 Pro64, SqlSer64 WinSer64
    Tuesday, February 23, 2010 8:57 PM
  • I would check the SQL Server errorlog file.
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    Wednesday, February 24, 2010 12:19 PM
    Moderator
  • I would check the SQL Server errorlog file.
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi

    I examined it first and pulled the error in question out of it. This is how I started the thread. That line on top (the OP) is from Sql Log.
    AlexB - Win_7 Pro64, SqlSer64 WinSer64
    Wednesday, February 24, 2010 3:30 PM
  • My experience is that we in the errorlog also would find the reason for the backup command to fail. Before or after this message. Without that reason, it is very difficult to comment, I'm afraid.
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    Wednesday, February 24, 2010 5:53 PM
    Moderator
  • Tibor, thank you. In essense it is a moot point. I finally backed all dbs up. I think the error was due to so maging parameter which I set up this morning. I resolved it in another thread. The issue has avolved since I posted, sidetracked and escalated but at the end I am happy that your routine (i believe it was you who pointed it out to me) works well. At least it does the backup but I will veryfy if the restoration is possible of course.

    Except that line there was nothing there related to that particular DB. Other dbs were backed up well but this failed because of time expiration I believe.

    I appreciate your help. Let's close the thread.
    AlexB - Win_7 Pro64, SqlSer64 WinSer64
    Wednesday, February 24, 2010 6:27 PM
  • Hi,

    This issue could be related to Harddisk failure events. Please check for event id 51 in sys logs. You shall find some traces to it.

     

    Thanks,

    Arun 

    Tuesday, January 04, 2011 2:53 PM