TabEst
asked on
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes Korbus it is viable for our situation
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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