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)
 URGENT
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ann
Posting Yak Master

218 Posts

Posted - 09/30/2009 :  09:54:48  Show Profile  Reply with Quote
So I accidently updated a bunch of records that I should not have....

Other than a backup, is there anyway I can get back the old data, as in transaction log?

mcrowley
Aged Yak Warrior

771 Posts

Posted - 09/30/2009 :  11:43:56  Show Profile  Reply with Quote
you can try to use Lumigent's Log Explorer, but the database would need to be in FULl recovery mode. Otherwise, the log entries are long gone.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 09/30/2009 :  12:13:30  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
And you would need to use the log explorer before the next transaction log backup.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 09/30/2009 :  17:00:00  Show Profile  Reply with Quote
What's wrong with a backup?

Just Restore it to a different db name on the same server

DONE



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 09/30/2009 :  17:07:21  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
quote:
Originally posted by X002548

What's wrong with a backup?


Nothing, if you have one....

--
Gail Shaw
SQL Server MVP
Go to Top of Page

ann
Posting Yak Master

218 Posts

Posted - 09/30/2009 :  18:20:03  Show Profile  Reply with Quote
Right - the "oops" happened after a backup was done
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36571 Posts

Posted - 09/30/2009 :  18:45:45  Show Profile  Visit tkizer's Homepage  Reply with Quote
If you use either FULL or BULK_LOGGED recovery, you can recover the data by doing a point in time restore via RESTORE DATABASE and RESTORE LOG.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
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.42 seconds. Powered By: Snitz Forums 2000