Until several days ago I had the SQL Server maintenance
job run daily without a problem. I am able to create a
backup from the MARK database manaully from SQL Server GUI
on the same drive as the maintenance job without a problem.
Please help me resolve the problem.
Thanks,
Dan
Aborted in the SQL Server Backup Maintenance on the VERIFY
DATABASE step:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
backup
device 'K:\dumpfiles\MARK\MARK_db_200406170903.BAK'.
Device error or device off-line. See the SQL Server error
log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY
DATABASE is terminating abnormally.
SQL Server Errorlog Backup Failed:
BackupDiskFile::OpenMedia: Backup
device 'K:\dumpfiles\MARK\MARK_db_200406170903.BAK' failed
to open. Operating system error = 2(The system cannot find
the file specified.).
I executed statement listed below in the Query Analyzer
created the backup file without a problem.
BACKUP DATABASE [MARK] TO DISK
= 'K:\dumpfiles\MARK\MARK_db_200406170803.BAK' WITH
NOINIT , NOUNLOAD , NAME = N'STARUAT backup', NOSKIP ,
STATS = 10, NOFORMATThe error seems during a verify stage. Can you run a RESTORE VERIFYONLY on
the backup created, from Query analyser?
thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
No comments:
Post a Comment