March 16, 2011 at 3:36 pm
Hello Everyone.
We've been pulling our hair out for the past day or two. Here's a summary of what is going on:
Trying to create a test db from a production backup. We first create an empty DB called "TESTIMIS" then try and restore a production backup to it. Tried doing it through the GUI and from TSQL, both with no luck.
SPECS
-Windows Server 2k3 SP2
-SQL 2000 (8.00.760)
ERROR CODES
After about 60 percent restored it gives me this:
Server: Msg 3203, Level 16, State 1, Line 2
Read on 'D:\MSSQL\BACKUP\PRODIMIS_db_201103100100.bak' failed, status = 2. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
SQL Log detail:
BackupMedium::ReportIoError: read failure on backup device 'D:\MSSQL\BACKUP\PRODIMIS_db_201103100100.bak'. Operating system error 2(The system cannot find the file specified.).
SCRIPT
Here is the script I'm running:
restore filelistonly from
DISK = 'D:\MSSQL\BACKUP\PRODIMIS_db_201103100100.bak'
ALTER DATABASE TESTIMIS
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
Go
RESTORE DATABASE TESTIMIS
FROM DISK = 'D:\MSSQL\BACKUP\PRODIMIS_db_201103100100.bak'
WITH REPLACE,
MOVE 'iMIS_Data' TO 'D:\MSSQL\Data\TESTIMIS\TESTIMIS.MDF',
MOVE 'iMIS_Data2' TO 'D:\MSSQL\Data\TESTIMIS\TESTIMIS_2.NDF',
MOVE 'iMIS_Log' TO 'D:\MSSQL\Data\TESTIMIS\TESTIMIS_log.LDF',
MOVE 'iMIS_Log2' TO 'D:\MSSQL\Data\TESTIMIS\TESTIMIS_log_2.LDF',
STATS = 10
The weird thing is after it fails I can go into the folder and I see the MDF and LDF files for the TEST database and the sizes of them all seem to be the same size as those from the backup.
Any help on this would be greatly appreciated.
Thanks,
Justin
March 16, 2011 at 3:41 pm
Sorry moderators, posted in the wrong place.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply