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 |
|
russler01
Starting Member
5 Posts |
 Posted - 2008-07-20 : 12:39:06
|
| I am having a real issue... My server has crashed and I have about 12 databases that were not backed up but I do have the mdf files to them. The problem is that they were not detached and I can't attach them because they are still showing open. How can I attach or restore a database that was not detached from there server. All I have access is to the files there is nothing else left on the server. Any help would be great!Thank you,Rusty |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-20 : 12:57:20
|
| Do you have the ldf (transaction log) files? If so, try an attach using both. It should work.SQL 2000 or SQL 2005?Why no backups?--Gail ShawSQL Server MVP |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-20 : 22:26:10
|
| How can be open if not loaded in sql instance? Tried with sp_attach_single_file_db? |
|
|
|
|
|
|
Attach a non detached database