Question Locked

Tracking deleted table objects in SQLServer 2000 or 2005

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

Can anyone just guide to know, or is it possible to recover the deleted table from a a database or at least the data by using mssql server 2005 scripts.

2 replies

by tony hopkinson

If so, you could try a restore table, though that one always make me nervous.

Otherwise you restore the back up to another database, export / transfer the table. Then cope with anything that's missing or broken.

A tip for you. Rename the table instead of deleting it OldName_ToDelete say.
Then when you are really really really confident about deleting it, then hit the button after you've done a backup. You know just in case you confidence was misplaced.

If you've got nothing, it depends on your schema, you could try and rebuild it from information in other tables, depends on how much and how useful.

If you are looking for undelete, I'm afraid it's hard luck matey.

This discussion is closed to new replies.