Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reydp
Starting Member
5 Posts |
 Posted - 2004-08-10 : 05:07:09
|
| Transaction Log seems to grow fast.How can I truncate this Transaction log without affecting the database integrity?thanks n advance. |
|
|
reydp
Starting Member
5 Posts |
Posted - 2004-08-10 : 05:45:40
|
| one server version is 7 and one is 2000,I can't see the option:Before this make sure there are free entries by setting the recovery model to simple or backing up the log.Enterprise managerRight click on the database, All tasks, Shrink database, Files, Select log file, OK.from this url : http://www.nigelrivett.net/TransactionLogFileGrows_1.htmlI think it is not available in sql server 7.what other options do I have? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-10 : 12:41:50
|
| You need to change your recovery model to SIMPLE if you are not going to backup the transaction log. Once you have done that, you can then shrink the LDF file down as it will have free space in it now.Tara |
|
|
|
reydp
Starting Member
5 Posts |
Posted - 2004-08-10 : 22:29:24
|
| Thanks Tara,I can't find the Recovery Mode in OPTION tab in PROPERTIES of the DB.This could not be available in SQL SERVER 7.Can I do this manually?If yes, How?Can you guide me through this, as I am really new in SQL SERVER.thanks in advance. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-08-11 : 05:28:33
|
| For 7 I think the setting is "truncate log on checkpoint"-------Moo. :) |
|
|
|
|
|
|
Transaction Log Maintenance