Posted by Erland Sommarskog on 09/21/05 14:08

(gurdipv@gmail.com) writes:
> I recently deleted the directory
> C:\Program Files\Microsoft SQL Server\MSSQL\Data
>
> On my production database server.
> I managed using undelete software to get back most of the LDF/MDF files
> and reattached them.
>
> But there are a few that simply do not reattach.
> Ive tried using
>
> sp_attach_db
> sp_attach_single_db
>
> But to no avail.
>
> I realise that the databases were not unattached properly.
>
> Is there a way to get the databases back into Enterprise Manager?
> Without starting again or using an expensive product like
> officerecovery.com SQL to recover?

If the error message are what I fear, the answer is: yes, you may be able
to get the databases back, but those ways are dangerous and can lead to
severe corruption, and requires complete understanding of what you are
up to. If those databases are dear to you, you should open a case with
Microsoft support.

But start with posting the error message, so we can verify that the problem
is not a more trivial one.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]