Re: Transaction log ???

I don't really understand your first question, but the log is there to
ensure that all changes to the database can be rolled back/forward if
necessary, such as when the server crashes. See "Transaction Logs" in
Books Online. As for shrinking it, see here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;272318&Product=sql2k

If you don't need transaction log backups (see "Selecting a Recovery
Model" in BOL), then the simplest option may be to set your database to
the simple recovery model - the log will then be truncated
automatically.

Simon

.

Relevant Pages

  • Re: Transaction logs getting too large
    ... If you don't care about transaction logs you can set the recovery model to simple ... ALTER DATABASE YourDatabase SET RECOVERY SIMPLE ... You will probably need to shrink the log file after setting the recovery model to simple. ...
    (microsoft.public.sqlserver.server)
  • Re: archive logging the log file
    ... I believe you are referring to transaction logs. ... transaction logs for databases in the FULL or BULK_LOGGED recovery model is ... backups in conjunction with database backups as part of your recovery plan. ...
    (microsoft.public.sqlserver.server)
  • What is the best practice to create Maintenance Plans
    ... There is not a definitive answer to the question of which backup is better. ... the database can be recovered to the point ... Full Recovery or Bulk-Logged Recovery model. ... Transaction Log backup for master database is not allowed. ...
    (microsoft.public.sqlserver.security)
  • RE: What is the best practice to create Maintenance Plans
    ... > If master is damaged in some way, for example because of media failure, an ... > With the Simple Recovery model, the database can be recovered to the point ... > Full Recovery or Bulk-Logged Recovery model. ... > Transaction Log backup for master database is not allowed. ...
    (microsoft.public.sqlserver.security)
  • Re: Error in Exchange
    ... play in .edb file or with database and how information is saved into .edb ... You really should try to find the hardware issue first as it will most ... On Oct 6 I again take a full backup of exchange and as you know, ... transaction logs are saved in that backup. ...
    (microsoft.public.exchange.admin)