开发者

SQL Server - What's in that log backup?

So I noticed that one of my log backups is about 1开发者_开发百科000x larger than normal. I'd like to see what is in there. Is there something I can use to read it?

Thanks!


Third party tools

http://www.red-gate.com/products/SQL_Log_Rescue/index.htm (Free but SQL2000 only - You don't state a version)

http://www.apexsql.com/sql_tools_log.asp (Quite pricy though it seems to have a trial version. I'm not sure what limitations this might have.)

I guess if you're that curious and haven't got a spare $999 you could use the backups to restore the relevant 2 copies of the database then do a data compare between the 2 versions.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜