PhilM99 (9/24/2009)

---

Thanks to Silverfox and ALZDBA for the quick replies!

OK, if I do this am I on the right track?:

1) Manually:

Set recovery model to Full

Do a log backup using the DBCC command with INIT to get the log file contents to a reasonable size

Do a Shrinfile of the log using the DBCC command to get the file size back down

2) Set up scheduled jobs steps to

Backup the database fully in the middle of the night

i.e. BackupLOG with NOINIT, BACKUP Database with INIT (what does that mean, I'll look itup)

Schedule an Incremental Backup of the log, say, hourly during daylighthours (that's probably NOINIT, too)

at some point schedule a log backup with INIT (I don't get that part)

ALZDBA, I don't understand why you have the complex arrangement of jobs modifying the schedule of other jobs. What is it that you are achieving by doing that?

Thanks