Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sql restore

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-03-07 : 08:44:05
daniel writes "I made a backup of my sql 2000 file (.bak) When I try and restore it I get the following error:

System.Data.SqlClent.SqlError: Directory lookup for the file "d:\sql\web.mdf" failed. The system cannot find the file specified.

Whats strange is shouldn't a .bak file not need an mdf file??? my db is sql 2000 but i am trying to restore it to sql server 2005. Could that be why? I would think microsoft would allow previous versions to be restored to new version.

Please help!"

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-03-07 : 10:58:59
Is the .bak file on the SQL Server computer, and is there a folder named D:\SQL on the SQL Server computer?
Go to Top of Page
   

- Advertisement -