URGENT HELP!! I Drop the main table by error
-
I just drop by error one of the most importan tables of my database is there any why to recover it?
-
if you have previous days backup then can restore otherwise
-
I don't have a backup, the program that we have to make backups does have enough licenses, so I guess know they will buy more.
-
You don't need a license to execute BACKUP DATABASE.
Eddie Wuerch
MCM: SQL -
so true, I don't have excuse, it was my mistake.
Someone else drop the table but I don't have any backup.
-
I think you can restore the table using your transaction log file, if your database is in full recovery mode. Pls go thru the following link for a third party tool that restores even deleted tables:
http://www.red-gate.com/products/sql_log_rescue/SQL_Log_Rescue.pdf
I am not sure if we can restore deleted data or data objects without going for a third party tool. I am just a database programmer and have very limited knowledge about this. But hope someone experienced in DBA activities could help.
Kiran
-
So there is no backup done on your databases? If this work related, I am sure there is backup, ask the system guys.
-
There is no backup and my database wasn't on full recovery mode
-
Lesson learned...
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply