April 30, 2009 at 5:46 am
Hi,
A client has just upgraded their 2005 Server 32 bit Standard Edition to 2008 Server 64bit. They had standard SQL 2005 on the old server and a database to migrate to the new server where they now have SQL 2008 Standard 64bit. Problem when doing a restore on the new SQL i am getting an error:
System.Data.SqlClient.SqlError: Directory lookup for the file "d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\wce_site.mdf" failed with the operating system error 3(error not found). (Microsoft.SqlServer.Smo)
I f anyone can give me some ideas of things to try to get this working it would be great. Thaks in advance
April 30, 2009 at 5:59 am
If you are restoring from SQL 2005 back up on SQL 2008 , have you tried the restore copy script instead of GUI as well ?
If not suggest you to modify the below script accordingly and try , in case you dont have it.
Step 1 : get the logical path of backup file and then restore the database as listed below.
To get values of logical path run the following command
Example :
RESTORE FILELISTONLY
FROM DISK ='f:\BACKUP\NORTHWIND.BAK'
Step 2: Place the values of column LOGICALNAME in the command to create a new database with back-up file as listed below.
RESTORE DATABASE NORTHWINDTEST
FROM DISK = 'c:\BACKUP\NORTHWIND.bak'
WITH MOVE 'NORTHWIND_DATA' TO 'c:\DATA\NORTHWINDTEST.mdf',
MOVE 'NORTHWIND_LOG' TO 'c:\sql\test_data\NORTHWINDTEST.ldf'
-:-)
Cheer Satish 🙂
April 30, 2009 at 6:42 am
That worked great. Thanks for the help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply