Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ann
Posting Yak Master
220 Posts |
 Posted - 2007-04-17 : 15:46:25
|
| How can I view what's in the LDF file? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-17 : 16:08:58
|
| You need to purchase a third party tool such as Lumigent's Log Explorer.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
craig79
Starting Member
33 Posts |
Posted - 2007-04-18 : 06:07:53
|
| If u r too curious for now u can try using these commands...But with Care..For a better view of Transaction Log Contents u wil have to rely upon 3rd Party Tools.DBCC TRACEON (3604)DBCC log ({dbid|dbname}, [, type={-1|0|1|2|3|4}]) where: dbid or dbname - Enter either the dbid or the name of the databasetype - is the type of output, and includes these options:0 - minimum information (operation, context, transaction id)1 - more information (plus flags, tags, row length, description)2 - very detailed information (plus object name, index name, page id, slot id)3 - full information about each operation4 - full information about each operation plus hexadecimal dump of the current transaction log's row.-1 - full information about each operation plus hexadecimal dump of the current transaction log's row, plus Checkpoint Begin, DB Version, Max XDESIDby default, type = 0Remember to Set DBCC TRACEOFF (3604) after u finish up with this. |
|
|
|
|
|
|
|
|
LDF