Reduce Transaction Log size

[password99]

How do I truncate the transaction log file to reduce its size...it has become too big!

 

[mrdenny]

Backup the transaction log, and it will empty the file. Then you can shrink the file with DBCC SHRINKFILE.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[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.