Lynn Pettis (11/13/2012)

---

Sounds like you are rebuilding indexes in your maintenance plan. Index rebuilds are a fully logged operation. Even if you switched to bulk logged recovery model...

GilaMonster (11/9/2012)

---

You should have two separate plans, one that does full backups and runs however often is required for full backups and a second plan that does log backups and...

If I decide to run a DBCC DBREINDEX job in the future (from inside Query Analyzer I assume?) do I have to put the DB in Single User mode before...

george sibbald (11/6/2012)

---

size your log to handle the largest log backup, I would guess it is already around 2GB? I would presume this log backup is after your reindex job....

george sibbald (11/5/2012)

---

For the data file I would say about 100MB, certainly avoid growth factors stored as a percentage. For the log file a growth factor of 64MB. As for...

Thanks so much for the info, George. I'll uncheck that shrink option and keep an eye on the size.

I'll have to brush up on how to best adjust the...