Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

Urgent: SQL Server DB Changes Recovery

Hello,

We made changes to some records of an SQL Server 2012 database, is there a way to recover it? or check logs which will reveal the changes?

We do not have a recent backup, which is a big mistake.

Please help.

Thanks
0
TabEst
Asked:
TabEst
  • 2
2 Solutions
 
KorbusCommented:
SQL server transaction logs should store that information. (without backup active, these should not have been truncated yet- and might be getting pretty large)
Here is a post on how to read those logs (though I'm not sure how helpful it will be- let me know if more info needed):
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/e64f6f30-fd62-4ac4-b8bf-bef98b85ecbe/how-do-i-view-the-transaction-log-in-sql-server-2008?forum=sqldisasterrecovery
0
 
KorbusCommented:
Oh,  you can also "undo" the transaction logs, back to a certain date.  I'm not sure if this is viable for your situation, but it might be as close to restoring a backup as you'll be able to get.

http://stackoverflow.com/questions/16945254/how-to-perform-sql-roll-back-from-transaction-logs
0
 
TabEstAuthor Commented:
Yes Korbus it is viable for our situation
0
 
rk_india1Commented:
SQL Server transaction logs contain records describing changes made to a database. They store enough information to recover the database to a specific point in time, to replay or undo a change. But, how to see what’s in them, find a specific transaction, see what has happened and revert the changes such as recovering accidentally deleted records To see what is stored in an online transaction log, or a transaction log backup is not so simple Opening LDF and TRN files in a binary editor shows unintelligible records so these clearly cannot be read directly. For instance, this in an excerpt from an LDF file: -

See more at: http://solutioncenter.apexsql.com/read-a-sql-server-transaction-log/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now