Click here to Skip to main content
15,936,565 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am trying to restore a database on MSSQL 2005 from backup of database which is created on SQL SERVER 2000.

On SQL server 2005 server , database compatibility level set to (80).

I am trying to run following for restore,
SQL
ALTER DATABASE IWT
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
RESTORE DATABASE IWT
FROM DISK = 'C:\IWT.bak'
WITH MOVE 'IWT_Data' TO 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RAR_Data.mdf',
MOVE 'IWT_Log' TO 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RAR_log.ldf',
REPLACE

ALTER DATABASE IWT SET MULTI_USER
GO

but getting error as,
SQL
Msg 3201, Level 16, State 2, Line 4
Cannot open backup device 'C:\IWT.bak'. Operating system error 2(error not found).
Msg 3013, Level 16, State 1, Line 4
RESTORE DATABASE is terminating abnormally.

I have tried all resources available online but no luck.
Posted
Updated 14-Nov-12 6:25am
v3
Comments
Corporal Agarn 14-Nov-12 13:31pm    
Is the file IWT.bak on the server where it is to be restored?
Is the backup password protected?
Does the backup have more than one backup?
vikram_shinde 14-Nov-12 13:34pm    
Backup file is on local machine and it has to be restored on SQL server running on same local machine.

Backup is not password protected also there are no more than one backup files.

1 solution

Read my article on how to use google. I googled the error message and found this[^].

Oops, the answer is there, but in the comments, the actual answer is here[^].
 
Share this answer
 
v2
Comments
vikram_shinde 14-Nov-12 14:01pm    
I have been through this article. But still getting error.
Christian Graus 14-Nov-12 14:03pm    
Then you should tell us what you've tried already so we know where you're at, instead of asking us to some how magically sense it. Does the file exist ? Are you sure the file is not corrupt ? It sounds to me like it could be.
vikram_shinde 14-Nov-12 14:18pm    
I tried - giving file name in different ways, properly checked for any typos by me,
changed file location . Yes, file actually exists on hard drive. I will check for whether file is corrupted.
Christian Graus 14-Nov-12 14:19pm    
It sure sounds to me like it is.
vikram_shinde 15-Nov-12 7:23am    
You are right, backup file is corrupted.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900