SQL Server Forums - restoring a table after its been deleted.

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

restoring a table after its been deleted.

New Topic

Reply to Topic

Printer Friendly

Author

Topic

alistair4267
Starting Member

10 Posts

Posted - 09/01/2008 : 05:56:44

Hello

just a quick question.

If i have deleted the contents of a table and haven't taken a backup of it, is it possible to restore the contents of that table that i deleted ???

so SQL 2005 have any sort of TombStone Restore like exchange 2003 does ?????

regards
alistair

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 09/01/2008 : 08:46:42

Not without a backup.

You might (emphasis might) be able to use a log recovery tool to recover deleted rows. I don't know if there's one for SQL 2005, they've not free and they're not guaranteed to work, especially if the DB is in simple recover model.

--
Gail Shaw
SQL Server MVP

afrika
Flowing Fount of Yak Knowledge

Nigeria
2702 Posts

Posted - 09/01/2008 : 09:07:09

quote:
Originally posted by alistair4267

Hello

just a quick question.

If i have deleted the contents of a table and haven't taken a backup of it, is it possible to restore the contents of that table that i deleted ???

so SQL 2005 have any sort of TombStone Restore like exchange 2003 does ?????

regards
alistair

Familiar road

Rule of thumb. Never use dynamic SQL and always backup

alistair4267
Starting Member

10 Posts

Posted - 09/01/2008 : 11:05:50

Thanks for all your help

i have decided to put this to rest for now.

i have also setup a job to do a daily backup of our DB's

regards
alistair

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.