log file - beginner question

Hi,
How I can view information stored into database log file (transaction log)?
Do I have any option to choose what kind of information will be registered
there? And finally: when I create database I have two option log file:
unrestricted file growth or restricted file growth to xxx MB. Is there any
way to ensure that when log file size reach max size then automatically
oldest entries are removed (rights now in such situation any operation on
database cause error).
MarcinRead the section in BOL (Books On-Line) on Backing Up and Restoring
Databases. Pay special attention to the section on Selecting a Recovery
Model. This will describe the function of the transaction log and what the
various choices do. Each choice has specific features and requirements so
read carefully before picking something and moving on.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Marcin" <kevin123@.poczta.onet.pl> wrote in message
news:bhbf70$26mu$1@.foka.acn.pl...
> Hi,
> How I can view information stored into database log file (transaction
log)?
> Do I have any option to choose what kind of information will be registered
> there? And finally: when I create database I have two option log file:
> unrestricted file growth or restricted file growth to xxx MB. Is there any
> way to ensure that when log file size reach max size then automatically
> oldest entries are removed (rights now in such situation any operation on
> database cause error).
> Marcin
>
>|||>How I can view information stored into database log file (transaction log)?
Log Explorer from www.lumigent.com is one way
>Do I have any option to choose what kind of information will be
registeredthere?
SQL2000 has the concept of recovery models that determine logging
charcteristics of transactions (FULL,BULK LOGGED,SIMPLE). For more
information look up Recovery Models in BOL
>automatically oldest entries are removed
SIMPLE recovery mode will truncate the transaction log when it gets 70% full
assuming there are no open long running transactions. Regular log backups in
the other recovery models will have the same effect.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Marcin" <kevin123@.poczta.onet.pl> wrote in message
news:bhbf70$26mu$1@.foka.acn.pl...
Hi,
How I can view information stored into database log file (transaction log)?
Do I have any option to choose what kind of information will be registered
there? And finally: when I create database I have two option log file:
unrestricted file growth or restricted file growth to xxx MB. Is there any
way to ensure that when log file size reach max size then automatically
oldest entries are removed (rights now in such situation any operation on
database cause error).
Marcin