Transaction Logs

From: "Johan Strange" <JohanStrange@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 30 Aug 2005 13:31:13 -0700

Hi, I have a database with a Transaction log that seems to be growing
rapidly. Currently 2.6Gb, I am new to SQL Server and am looking for a way to
introduce a way to control the growth size like Circular logging in Exchange
Server. Can anyone give me some ideas please.

BRGDS

Johan
.

Follow-Ups:
- RE: Transaction Logs
  - From: Johan Strange

Prev by Date: Patching WMSDE on WSUS with MSDE SP4
Next by Date: RE: Transaction Logs
Previous by thread: Patching WMSDE on WSUS with MSDE SP4
Next by thread: RE: Transaction Logs
Index(es):
- Date
- Thread

Relevant Pages

Re: Transaction log problems
... IF you have to shrink a database or file it ... sure that you get that database backup on tape or to another machine. ... > We are using SQL Server 2000 on Windows Server 2003 Standard Edition, ... > One of the databases has recently begun showing large growth of the> transaction log and it is causing us some problems. ...
(microsoft.public.sqlserver.server)
Re: Transaction Log Size
... listed in my article has detailed info on shrinking of the transaction log. ... Tibor Karaszi, SQL Server MVP ... > (database + transaction log) with fake appended to the name. ... >> CommVault to backup the backup files. ...
(microsoft.public.sqlserver.server)
Transaction log problems
... We are using SQL Server 2000 on Windows Server 2003 Standard Edition, ... transaction log and it is causing us some problems. ... Because the database is used by the third party software, ... transaction log file and I would not have to monitor it so closely. ...
(microsoft.public.sqlserver.server)
Re: Transaction Log Size
... Backup database does not empty the transaction log files. ... How to Shrink the SQL Server 7.0 Transaction Log ...
(microsoft.public.sqlserver.server)
Re: HDD still full after shrinking transaction log
... So that is the first question: why does the log keep growing? ... In the first case, you should run with full recovery, and backup your ... SQL Server will then truncate the transaction log regularly. ...
(comp.databases.ms-sqlserver)