How to view transaction log for SQL Server 2005

  • DBCC Log(dbname)




    My Blog: http://dineshasanka.spaces.live.com/

  • Note that the log is restarted when the logs are cycled or SQL is restarted. That can be a long interval, and the logs can be big. So they can be slow to open, especially if you use something like notepad/wordpad.

    The viewer in SSMS is what I'd recommend.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply