Home All Groups Group Topic Archive Search About

I want to recover deleted database from SQL Server 2000



Author
21 Nov 2007 11:12 AM
skbhaduri
Hi All

Somebody deleted a database from my SQL Server 2000 server and I have
to recover it. I dont have any backup of the database. Can anyone
help ?

Thanks
S. K. Bhaduri

Author
21 Nov 2007 2:08 PM
TheSQLGuru
If the physical files still exist you can try to attach them back.  See
sp_attach_... in BOL.  If the physical files don't exist and you don't have
a backup of them you really are hosed.

--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.


<skbhad***@gmail.com> wrote in message
Show quoteHide quote
news:beb70e65-6c51-41b5-a063-7ce4d8f4b4de@w28g2000hsf.googlegroups.com...
> Hi All
>
> Somebody deleted a database from my SQL Server 2000 server and I have
> to recover it. I dont have any backup of the database. Can anyone
> help ?
>
> Thanks
> S. K. Bhaduri

Bookmark and Share