Hello Everyone and thanks for your help in advance. I am trying to backup a SQL Server 2000 database to an external hard drive. I am attempting to do a complete backup, however, each time I attempt this I receive the follwoing error:
Write on "M:\SQL Server\MYDATABASE.bak' failed, status = 1117. See the SQL Server error log for more details.
BACKUP DATABASE is terminating abnormally
In the event viewer, I receive Event ID 17055 with the message:
BACKUP failed to complete the command BACKUP DATABASE [KidsLocal] TO DISK = N'M:\SQL Server\MYDATABASE.bak' WITH INIT , NOUNLOAD , NAME = N'MYDATABASE backup', NOSKIP , STATS = 10, NOFORMAT