Decreasing the size of the Transaction Log

[CasperTFG]

Hello All,

My first time posting to this Forum, I'm usually in the programmers forums. Anyway...

We have an SQL Server database that our program uses. The Database is quite large and we have maintenance plans that trim off log data kept in it to keep only 3 months worth of history data. We obviously look at SQL Server from a programmers perspective, not as DBA's.

What we have noticed is that the Transaction log keeps growing, and while our _DB.MDF file is kept to under 2 GB, the _LOG.LDF file has grown at one site to over 6 GB, obviously filling up the drive and halting SQL Server.

My questions are:

1) How do we decrease the 6 GB log file now?

2) Can we move the log file to a different drive? The current drive is a SCSI at 10 GB, however there are other drives 65 GB, non SCSI.

3) How should we set up the DB so that the log file will stay managable?

Thanks,


Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".

 

[nigelrivett]

see

http://www.nigelrivett.net/TransactionLogFileGrows_1.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.