SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
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 Previous Topic Topic Next Topic  

alistair4267
Starting Member

10 Posts

Posted - 09/01/2008 :  05:56:44  Show Profile  Reply with Quote
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  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 09/01/2008 :  09:07:09  Show Profile  Reply with Quote
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

Go to Top of Page

alistair4267
Starting Member

10 Posts

Posted - 09/01/2008 :  11:05:50  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000