Post reply

Backup issue

  • March 2, 2013 at 9:46 am

    #269263

    Hi All,

    I have a 80B database in SQL Server 2000 and i migrating to SQL Server 2008 through side by side. When i taking backup through GUI or QUERY but not successfully taking getting automatically disconnected. When i checked in ERROR LOG get below massage.

    3041 :

    BACKUP failed to complete the command

    backup database DBNAME to

    Disk = 'D:\Dbname\part1.bak',

    Disk = 'D:\Dbname\part2.bak',

    Disk = 'D:\Dbname\part3.bak',

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.%5B/b%5D

    Some where i saw this error like space issue but my 'D' Drive is 600GB free.

    Let me know what is the issue???

    Thanks in advance

    Satish

  • March 2, 2013 at 11:49 am

    #1592694

    Based on the following from MSDN, what other errors are there in the SQL Server Error LOG?

    Error 3041

    Severity Level 16

    Message Text

    BACKUP failed to complete the command %.*ls

    Explanation

    This error indicates that Microsoft® SQL Server™ could not complete the BACKUP of the specified database due to a previous error. The BACKUP command that failed is given at the end of the error message. This message also appears in the Microsoft Windows NT® application log.

    Action

    To determine why the BACKUP failed, examine the Microsoft SQL Server error log for any errors prior to error 3041.

Viewing 2 posts - 1 through 1 (of 1 total)

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