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?
I appreciate anybodies help on this.
GurdipYou didn't mention backups. Does that mean you don't have any backups?
What does "do not reattach" mean? Do you get an error message? It might
be possible to advise you better if we knew that and the exact
sp_attach statement you used.
Before you do anything at all please, please take a backup!
--
David Portas
SQL Server MVP
--|||(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/techin.../2000/books.asp
