April 6, 2005 at 3:07 pm
I accidentally deleted a table in my database, the database is not being backed up. Can I restore the database to a point before the deletion, if so, how do I do it.
April 6, 2005 at 3:50 pm
Unless you have a transaction log tool installed, such as Lumigent's Log Explorer, and the database is in full recovery model, no. Hard lesson learned. Take backups!
Steve
April 7, 2005 at 8:57 am
If there are NO backups at all, you're out of luck.
If you have an old full backup you can restore it giving it a different name then you can copy the table to your database. This assumes that an "old" version of the table will be useful.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 7, 2005 at 12:30 pm
ahhh ... another convert to the religion of 'backup' ...
remember ... a DBA is only as good as the last backup he can restore ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply