Click here to Skip to main content
14,420,468 members
Rate this:
Please Sign up or sign in to vote.
See more:
I would like to know if there is a feature for reading SQL transaction logs in SQL Server 2014 CTP2.

I have tried to find some help on their site but there was nothing there I could use.

I bumped into this post[^], presenting some details on viewing SQL transaction logs in SQL Server 2008.

I am currently using SQL Server 2014 CTP1 and I’ve tried to find this feature, but unsuccessfully.

My team have had a lots of trouble with accidental deletes or updates, so it would be great if someone knows more on including this feature in SQL Server 2014.
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Hi,

Interesting question, and as far as I know MS didn't plan to include this feature in SQL Server 2014. I believe their current focus is on enterprise level features (high availability, and similar).

To help you with your issues, I can recommend trying DBCC LOG and fn_dblog undocumented commands for viewing transaction logs.

Another option is using commercial tools, like ApexSQL Log[^].

Finally, you may want to try Change data capture (CDC) feature, which is included in SQL Server by default but only available in enterprise edition.
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100