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)
 Restore Trouble

Author  Topic 

rwlopez
Yak Posting Veteran

80 Posts

Posted - 2006-11-28 : 16:31:54
I a have restored a .mdf and a .ldf file from back up, but I get a message when I try to copy and paste the files or if I try to re-attach them saying that the file is in use. Has anyone had this problem?

X002548
Not Just a Number

15586 Posts

Posted - 2006-11-28 : 16:37:04
Sounds like you are trying to copy the actual datafiles sql server uses...and yes they would be in use

You need to restore from a backup



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

rwlopez
Yak Posting Veteran

80 Posts

Posted - 2006-11-28 : 16:43:07
No, The files that I am trying to use are files that have been restored they are not attached to SQL server. Nothing should be using them. They were even restored to a different directory.
Go to Top of Page

rwlopez
Yak Posting Veteran

80 Posts

Posted - 2006-11-28 : 16:52:37
I got it. Stopping the SQL service allowed me to do what I wanted to so. Still not sure why, since these were restored file that were not attached to SQL Server.
Go to Top of Page
   

- Advertisement -