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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-27 : 11:12:57
|
| Ismail Hamid writes "I couldn't attach a single database to SQL Server 7.0 using sp_attach_db_single.It keeps saying "Database cannot be opened because some of the files couldn't be activated" Error 945,Level 14,state 2 ,line 1.I don't have the log file, nor a backup.I copied the mdf file from different SQL Server PC because it has a bad hard drive and always hangs.The new server has the same character set and Sort order as the old one.Is there any solution ???" |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-08-27 : 12:06:13
|
| See the following threads - they MAY help. Did you sp_detach, or just copy the file ? Did you make a backup ?[url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=19121[/url][url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=19030[/url]HTH |
 |
|
|
|
|
|
Attaching Single Database