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
 Transact-SQL (2000)
 DataBase backup

Author  Topic 

suman.reddy39
Starting Member

34 Posts

Posted - 2008-10-22 : 07:13:49
hi all,
i need a small help urgently please hepl me in this issue.
unfortunately one of my database is been deleted, is there any cahnce to get it back as i have no backup of that database.

thanks in advance...

Don't go the way Life takes you, Take the Life the way you go

subbi

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-10-22 : 07:34:44
The simpe answer is no. This is what backups are for.
Go to Top of Page

acollins74
Yak Posting Veteran

82 Posts

Posted - 2008-10-22 : 07:42:16
Rick is right, that is what backups are for but there are some things you should at least check.

How do you know the DB was deleted? Did someone tell you that?

Search the drive for the .mdf files. Maybe the db was detached.

Also, do you have an Backup Department that may have been sweeping the drives and can provide some support for your recovery.

Go to Top of Page

suman.reddy39
Starting Member

34 Posts

Posted - 2008-10-22 : 07:55:35
thank you for your suggestion but as you said i dont have that backup dept.

Don't go the way Life takes you, Take the Life the way you go

subbi
Go to Top of Page
   

- Advertisement -