Log File Bloating - Preventative Maintenance
- From: Always OpenTo Suggestions <AlwaysOpenToSuggestions@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 21 Apr 2009 10:40:02 -0700
I've got SQL SERVER 2000 and 2005 database which are updated using an ACCESS
application. The .MDF is around 5 gig and the log file recently got up to 25
gig. To debloat the file, I:
-- change the Restore Method to SIMPLE
-- backup the database
-- shrink the log file
-- then change Restore Method back to Full.
I do a full backup every night.
I think I need to keep the Restore Method to Full in case I have a mid-day
crash!
Every month or so I manually shrink the file as described above.
I'm thinking about creating a nightly routine to automate the steps above.
My questions are:
-- Is the above method a sound practice?
-- Is there any reason I should not automate the above process nightly? (or
weekly)
-- Am I just missing the boat completely?
Thanx in advance!
Angelo
.
- Follow-Ups:
- Re: Log File Bloating - Preventative Maintenance
- From: B.Edwards
- Re: Log File Bloating - Preventative Maintenance
- Prev by Date: Re: Is SQL Server the right platform?
- Next by Date: Re: Log File Bloating - Preventative Maintenance
- Previous by thread: Is SQL Server the right platform?
- Next by thread: Re: Log File Bloating - Preventative Maintenance
- Index(es):