I am trying to use the backup facility on SQL Server 7.0. When I try to backup to a device or file. I get the following error message:
Cannot open backup device temp_2. Device error or device off-line. See the SQL Server error log for more details. Backup or Restore operation terminating abnormally.
I also tried running the backup as a query shown below:
EXEC sp_addumpdevice 'disk', 'MyNwind_1', 'c:\mssql7\backup\MyNwind_1.dat'
-- Back up the full MyNwind database.
BACKUP DATABASE PatientData TO MyNwind_1
This produces the error as shown below:
'Disk' device added.
Server: Msg 3202, Level 16, State 1, Line 6
Write on 'MyNwind_1' failed, status = 112. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 6
Backup or restore operation terminating abnormally.
Is anyone aware of the possible cause of this error and where do I find the error log file which should give more details.
I look forward for a reply.