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.
Author |
Topic |
mrinmoy
Starting Member
2 Posts |
Posted - 2007-10-05 : 03:09:30
|
I have accidentally deleted a Database from SQL server 2005 instance. Is there any chance for me to recover the Database. If yes do let me know the method.Thanks in advance Mrinmoy |
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-10-05 : 04:11:43
|
what backups do you have in place?Em |
|
|
mrinmoy
Starting Member
2 Posts |
Posted - 2007-10-05 : 04:56:59
|
I have 3 days old backup.Mrinmoy |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
|
Kristen
Test
22859 Posts |
Posted - 2007-10-05 : 11:04:13
|
You MIGHT be able to use File Undelete for the MDF and LDF files.If you can there is a good change you can ATTACH them.Otherwise restore from backup, and put a maintenance plan in place that backups up ALL databases (even newly created ones) frequentlyKristen |
|
|
|
|
|