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)
 Orphan database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-02 : 09:41:49
Manuel RH writes "Can I attach a .mdf to a database ?..

I had SQL Server 7 running on D partition and the data files hosted on a different partition. Since my hard drive (D:\) crashed and I decided to make a fresh installation of SQL these files it simple becomes orphan.

I tried to imported them (failed)
I tried to restored them (failed)
I tried to create a database with the same and stoped the service and overwrite the files but the database became corrupted. (failed)
I tried sp_attach_db (failed)

Any other suggestion ?

Manuel"
   

- Advertisement -