Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL2000 SQL-server-2005 , +
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,
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,
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 14-Nov-12 4:35am
Edited 14-Nov-12 6:25am
v3
Comments
djj55 at 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 at 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

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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[^].
  Permalink  
v2
Comments
vikram_shinde at 14-Nov-12 14:01pm
   
I have been through this article. But still getting error.
Christian Graus at 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 at 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 at 14-Nov-12 14:19pm
   
It sure sounds to me like it is.
vikram_shinde at 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)

  Print Answers RSS
0 OriginalGriff 398
1 Sergey Alexandrovich Kryukov 320
2 Uma Shankar Patel 80
3 CB Sharma 79
4 PhilLenoir 70
0 Sergey Alexandrovich Kryukov 6,532
1 OriginalGriff 5,976
2 CPallini 2,473
3 Richard MacCutchan 1,687
4 Abhinav S 1,550


Advertise | Privacy | Mobile
Web04 | 2.8.140821.2 | Last Updated 14 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100