<div>
SQL server transaction logs should store that information. (without backup active, these should not have been truncated yet- and might be getting pretty large)<br />
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):<br />
<a href="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" rel="ugc nofollow">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</a>
</div>


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 [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]

<div>
Yes Korbus it is viable for our situation
</div>


Yes Korbus it is viable for our situation

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
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?<br />
<br />
We do not have a recent backup, which is a big mistake.<br />
<br />
Please help.<br />
<br />
Thanks
</div>
</div>


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

Urgent: SQL Server DB Changes Recovery

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.