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 |
|
vpathisseril
Starting Member
6 Posts |
 Posted - 2003-10-22 : 09:55:07
|
| I have SQL Server database. Total database size is close to 15Gb.The data file size is approximately 3.5 Gb, and set to Grow Automatically by 10% and Max file size is unlimited.The transaction Log file is set to close to 11.5 Gb, and set to Grow Automatically by 10% and Max file size is unlimited. Only about 500 mB of 11.5 used for transactions.Is there any possible way that I can change the size of he transaction log somewhat three GB Max. Because I am doing an hourly transaction log and full dB backup. I have tried Shrink, DBCC, and sp_detach the db, delete the ldf file, and tried to attach. And I tried my last resort, took a backup of the dB, delete the dB, recreate the dB, and restored, then also the translog file got created as same as 11.5 http://goEdeveloper.com/work |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-22 : 12:28:15
|
| Which shrink command did you use? There are two. Try them both. DBCC SHRINKDATABASE and DBCC SHRINKFILEI would consider taking more regular transaction log backups. We do ours every 15 minutes without any performance impact. If we did it only every hour, we would have huge transaction logs for at least two of our databases.Tara |
 |
|
|
|
|
|
Reduce the Tran's Log size