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 2000 Forums
 SQL Server Administration (2000)
 Attaching Database from CD

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-30 : 09:34:17
Cecil writes "I am trying to attach a database I've received on a cd to ms sql on a local server. The database is a backup file (.bak)

I've copied the database to the c drive on the local server.

When I try to restore through EM I get error messages which say the physical file location name may be incorrect.

Any help will be very much appeciated

Thanks"

Kristen
Test

22859 Posts

Posted - 2006-05-30 : 09:43:03
You have to mess around with the logical names, whether the database can be overwritten, and the physical locations - and to be honest I've always found it hard to understand in EM - particularly interpreting any error messages I got!

You might find using the SQL for a RESTORE easier. See:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example,Restore

Kristen
Go to Top of Page
   

- Advertisement -