SQL Server 2014 CTP2-读取SQL事务日志 [英] SQL Server 2014 CTP2– read SQL transaction logs
问题描述
我想知道是否有一个在SQL Server 2014 CTP2中读取SQL事务日志的功能。
我试图在他们的网站上找到一些帮助但是我什么也没用到。
我碰到了这个 post [ ^ ],提供有关在SQL Server 2008中查看SQL事务日志的一些详细信息。
我目前正在使用SQL Server 2014 CTP1,我试图找到这个功能,但是没有成功。
我的团队在意外删除或更新方面遇到了很多麻烦,如果有人知道更多关于在SQL Server 2014中包含此功能的话会很棒。
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.
推荐答案
有趣的问题,以及我知道MS不打算在SQL Server 2014中包含此功能。我相信他们目前的重点是企业级功能(高可用性,类似)。
为了帮助解决您的问题,我建议您尝试使用DBCC LOG和fn_dblog未记录的命令来查看事务日志。
另一种选择是使用商业工具,例如ApexSQL日志 [ ^ ]。
最后,您可能想尝试更改数据捕获(CDC)功能,默认情况下包含在SQL Server中但仅适用于企业版。
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.
这篇关于SQL Server 2014 CTP2-读取SQL事务日志的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!