Menu
If any of you have worked with a cool tool for viewing/querying the SQL Transaction logs, please let me know. This should show all the transactional sql statements which are committed or rolled back.
For Database files, if it has some additional graphical capabilities like showing the internal Binary Tree structure of the indexes, that will be awesome but I guess I am asking for too much huh..
523
Use DBCC OPENTRAN to verify whether an open transaction exists within the transaction log. The inactive part of the log can be truncated if you use the BACKUP LOG statement, an open transaction can avoid the log from truncating entirely. To recognize an open transaction, use sp_who to get the system process ID.
The data and transaction log files are stored in the root of the database directory. The database directory is the folder location specified when the database is created.
This is only relevant if you're talking SQL Server 2000 but RedGate produced a free tool called SQL Log Rescue. Otherwise, for SQL Server 2005 ApexSQLLog from ApexSQL is the only other product I'm aware of
88
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
