-
SQL Server Recurring Backup/Dump
I am running SQL Server 6.5 / Service Pack 4.
I am trying to backup a database on a daily basis. I want to be able to keep 2 dumps of the database on the backup device before reinitializing it. This is
the command that was generated by SQL Server:
DUMP DATABASE testDatabase TO testDevice VOLUME = `SS0003` WITH NOUNLOAD ,
STATS = 10, INIT , RETAINDAYS =2, NOSKIP
The backup runs fine the first day, but it fails on the second day. This error is consistent, the backup simply fails every other day. Here is the error generated:
Can`t open dump device `D:MSSQLBACKUP estDevice.DAT`, device error or device off line. Please consult the SQL Server error log for more details. (Message 3201)
The SQL Server error log has no entries for this error.
Any help would be greatly appreciated!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|