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)
 db will not attach

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-30 : 13:53:25
Chris writes "I have detached my database and now I can not attach the database. The log file was deleted. I've tried sp_attach_db or sp_attach_single_file_db and I get an error all the time. The error usually says - example "Device activation error" file name 'c:\mssql7\data\sample.mdf' may be incorrect. or says database 'sample' cannot be opened because some of the files could not be activated. What are all the possible solutions?
Thanks
Chris McCall"
   

- Advertisement -