May 16, 2006 at 12:39 pm
can you read the data recorded in transaction logs? if so, how?
sorry typo in title - won't let me edit.
May 16, 2006 at 12:46 pm
Yes and no. You really need a third-party software such as Lumigent's LogExplorer (and there are others). But I believe most of them need to be installed before you need to read the log file.
-SQLBill
May 16, 2006 at 4:05 pm
Log Explorer can read logs that were created before it was installed.
DC, you might try DBCC LOG to try to decypher what's in the T-log. It's not nearly as easy as one of the log reader tools. Here's an excerpt from an article by Alexander Chigrik:
DBCC log
This command is used to view the transactional log for the specified
database.
DBCC log ( {dbid|dbname}, [, type={-1|0|1|2|3|4}] ) |
PARAMETERS:
Dbid or dbname - Enter either the dbid or the name of the database
in question.
type - is the type of output:
0 - minimum information (operation, context, transaction id)
1 - more information (plus flags, tags, row length)
2 - very detailed information (plus object name, index name,
page id, slot id)
3 - full information about each operation
4 - 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 XACTID
by default type = 0
To view the transaction log for the master database, you can run the
following command:
DBCC log (master) |
Greg
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply