SQL Server Forums - DBCC LOG and transaction log file

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums

Profile | Active Topics | Members | Search | Forum FAQ

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

DBCC LOG and transaction log file

Reply to Topic

Printer Friendly

Author

Topic

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 07/09/2001 : 00:52:29

MHB writes "Dear Expert
I want to know how can I see SQL Server 7 transaction log files
for example I want to know User1 Updates/Adds/Deletes which rows of
which tables and when?
is there T-SQL or any other way to this purpose?
an expert suggest to me
DBCC log(PRS)
--prs is my DataBase
I wrote this statement in 'Query Analyzer MS Sql server 7'
and I 've get this statements

Current LSN            Operation          Context            Transaction ID 
---------------------- ------------------ ------------------ -------------- 
00000005:0000001e:0001 LOP_BEGIN_CKPT     LCX_NULL           0000:00000000
00000005:0000001f:0001 LOP_END_CKPT       LCX_NULL           0000:00000000
00000005:00000020:0001 LOP_BEGIN_XACT     LCX_NULL           0000:00000126
00000005:00000020:0002 LOP_DELETE_ROWS    LCX_MARK_AS_GHOST  0000:00000126
00000005:00000020:0003 LOP_SET_FREE_SPACE LCX_PFS            0000:00000126
00000005:00000020:0004 LOP_MODIFY_HEADER  LCX_PFS            0000:00000126
00000005:00000020:0005 LOP_DELETE_ROWS    LCX_HEAP           0000:00000126
00000005:00000020:0006 LOP_DELTA_SYSIND   LCX_CLUSTERED      0000:00000126
00000005:00000020:0007 LOP_COMMIT_XACT    LCX_NULL           0000:00000126
00000005:00000022:0001 LOP_BEGIN_XACT     LCX_NULL           0000:00000127
00000005:00000022:0002 LOP_MODIFY_HEADER  LCX_PFS            0000:00000127
00000005:00000022:0003 LOP_EXPUNGE_ROWS   LCX_INDEX_LEAF     0000:00000000
00000005:00000022:0004 LOP_SET_FREE_SPACE LCX_PFS            0000:00000127
00000005:00000022:0005 LOP_COMMIT_XACT    LCX_NULL           0000:00000127
00000005:00000023:0001 LOP_BEGIN_XACT     LCX_NULL           0000:00000128
00000005:00000023:0002 LOP_DELETE_ROWS    LCX_MARK_AS_GHOST  0000:00000128
00000005:00000023:0003 LOP_SET_FREE_SPACE LCX_PFS            0000:00000128
00000005:00000023:0004 LOP_MODIFY_HEADER  LCX_PFS            0000:00000128
00000005:00000023:0005 LOP_DELETE_ROWS    LCX_HEAP           0000:00000128
00000005:00000023:0006 LOP_DELTA_SYSIND   LCX_CLUSTERED      0000:00000128
00000005:00000023:0007 LOP_COMMIT_XACT    LCX_NULL           0000:00000128
00000005:00000025:0001 LOP_BEGIN_XACT     LCX_NULL           0000:00000129
00000005:00000025:0002 LOP_MODIFY_HEADER  LCX_PFS            0000:00000129
00000005:00000025:0003 LOP_EXPUNGE_ROWS   LCX_INDEX_LEAF     0000:00000000
00000005:00000025:0004 LOP_SET_FREE_SPACE LCX_PFS            0000:00000129
00000005:00000025:0005 LOP_COMMIT_XACT    LCX_NULL           0000:00000129

(26 row(s) affected)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

How can I use them ? what is the meaning of colomn of this query?how can I reach out to meaning of them?are
they in a table of sql server ?
Thank you for your complete answer."

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 07/09/2001 : 07:22:39

No, this is directly from the transaction log. Try using DBCC LOG(DBName,Option) Option being -1,0,1,2 or 3(I think these are all the values available). The Option part is how detailed you want the output. Takes a while to work out the meanings of each part of the log, but if you want an easier alternative, get Log Explorer from www.lumigent.com.

The meanings are explained in the header, if you can't understand it then you definately need Log Explorer as DBCC LOG() is an UNDOCUMENTED feature of SQL, which i'm sure you would have been told...

uri dimant
Starting Member

Israel
16 Posts

Posted - 07/10/2001 : 02:55:34

try undocumented command dbcc loginfo 'databasename'

Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.03 seconds.