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 |
|
munkdogg
Yak Posting Veteran
53 Posts |
 Posted - 2006-03-24 : 22:17:45
|
| Hello,I've read the article here; http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Shrink,Maintenance , but still have a question with re: to keeping the logfile growth reasonable.Currently there is no transaction log backup plan. Our DB's are relateively new, and until now there was no pressing need to have a P.I.T. restore, even though the recovery model is set to Full.That being said, I am looking to begin backup up the transaction log every 15 minutes. What I need to know, is do I run a greater risk of fragmentation by shrinking the .ldf prior to this backup plan being put into effect? (ldf's are currently about 150% the size of our .mdf's) I'm trying to be conservative about disk space, and truncating the log file may not really meet that goal.Thanks so much for any information you can provide. This forum is great!! |
|
|
|
|
|
Backups