Solved

Urgent: SQL Server DB Changes Recovery

Posted on 2014-01-18
4
232 Views
Last Modified: 2014-01-18
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
Comment
Question by:TabEst
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 10

Expert Comment

by:Korbus
ID: 39790793
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
 
LVL 10

Assisted Solution

by:Korbus
Korbus earned 100 total points
ID: 39790799
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
 

Author Comment

by:TabEst
ID: 39790811
Yes Korbus it is viable for our situation
0
 
LVL 5

Accepted Solution

by:
rk_india1 earned 400 total points
ID: 39791082
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

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question