0

I'm running SQL Server Express 9.0.4035 on Windows 7, and am having the following problem creating a new database from a backup file I've been given.

In the Restore Database dialogue I enter a new database name and select the file to restore from.

I then get the following error:

Directory lookup for the file "S:\SQLData\[new_db_name].mdf" failed with the operating system error 3(The system cannot find the path specified.).

What is S:/\, and why is it looking for this [new_db_name].mdf file, which won't exist yet?

1 Answer 1

0

The database backup contains the full path and filename of the original database. You simply need to change them to suit the server/system that you're restoring the backup to.

http://msdn.microsoft.com/en-us/library/ms186390.aspx

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .