anyone knows the anatomy to the transaction logs

how can i retrieve information from that very consuming tlogs.
Its consuming a lot of space maybe we can make relevant info from it
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787Lumigent Log Explorer can help you on that.
HTH, Jens Suessmeyer.|||thanks but thats not what i need.
do you dig deep into to the logs
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Jens" wrote:

> Lumigent Log Explorer can help you on that.
> HTH, Jens Suessmeyer.
>|||What do you want to do ? Look at the feature list of lumigent, perhaps
it=B4ll fit your needs.
http://www.lumigent.com/products/le_sql.html
HTH, Jens Suessmeyer.|||i want to generate reports from it without using
the log explorer
--
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Jens" wrote:

> What do you want to do ? Look at the feature list of lumigent, perhaps
> it′ll fit your needs.
> http://www.lumigent.com/products/le_sql.html
> HTH, Jens Suessmeyer.
>|||SQL Server doesn't provide any features for reporting from the logs.
You'd have to use third party tools for that. Logs are generally
unsuitable for business reporting requirements because any useful data
they contain is lost each time you do a log backup (which you should be
doing regularly if you are in Full Recovery mode). If you need to log
historical data then the transaction logs are not the way to do it.
David Portas
SQL Server MVP
--|||Hi Jose,
The details of the log are not released by Microsoft. The companies that
have products which read the log have done so by cracking the logs structure
themselves. Therefore you would be very (VERY) lucky if any of them are
willing to let you know what it is, as this is big money for them.
David right though even if you could read it reporting from it would not be
a good idea
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Jose G. de Jesus Jr MCP, MCDBA" <Email me> wrote in message
news:B42E3821-F9FC-4A1B-B87C-AD2698EBAB4D@.microsoft.com...
> how can i retrieve information from that very consuming tlogs.
> Its consuming a lot of space maybe we can make relevant info from it
>
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787|||thanks for the input guys
--
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Jose G. de Jesus Jr MCP, MCDBA" wrote:

> how can i retrieve information from that very consuming tlogs.
> Its consuming a lot of space maybe we can make relevant info from it
>
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787|||You can manage (but not entirely limit) the amount of space consumed by the
transaction logs by configuring the database recovery model and scheduling
transaction log backups / truncates.
"Jose G. de Jesus Jr MCP, MCDBA" <Email me> wrote in message
news:B42E3821-F9FC-4A1B-B87C-AD2698EBAB4D@.microsoft.com...
> how can i retrieve information from that very consuming tlogs.
> Its consuming a lot of space maybe we can make relevant info from it
>
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787