March 2, 2013 at 9:46 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy