June 3, 2003 at 12:46 pm
is there a utility somewhere to read a transaction backup log. I know exactly what time the error occured if i could read the log then i could find out how the user did it.
June 3, 2003 at 1:02 pm
June 3, 2003 at 1:25 pm
June 3, 2003 at 1:25 pm
June 3, 2003 at 3:52 pm
they have a low end version that just reads for around US$400. The higher end version will undo transactions by generating a script to undo the action.
I thought lockwood was releasing something soon to do this well. http://www.lockwoodtech.com/
Steve Jones
June 4, 2003 at 10:41 am
You mean the Transaction log? Or the transaction log Backup file? If you are referring to the T-Log
You can use
DBCC LOG (DBID/DBNAME, Type = 1/2/3/4)
This gives you only limited info
Shas3
June 5, 2003 at 1:40 pm
the trn file the backup file
quote:
You mean the Transaction log? Or the transaction log Backup file? If you are referring to the T-LogYou can use
DBCC LOG (DBID/DBNAME, Type = 1/2/3/4)
This gives you only limited info
June 6, 2003 at 12:01 am
Wondering where does this transaction log info stored in the SQL Server? How can Lumigent software can get the info while we can't?
Edited by - mlwang on 06/06/2003 12:02:38 AM
June 6, 2003 at 5:28 am
Great question - Y V Can't.
Shamshad Ali
June 9, 2003 at 6:01 pm
This command....
DBCC LOG (DBID/DBNAME, Type = 1/2/3/4)
...I can't seem to find it in BOL. What is the BOL topic if it exists, or is there any other info I could find?
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply