log size control

  • I have an SP now that does the defrag on the database that is passed as a variable to it on any index that has a defrag level about 35 %. It sets the recovery model to simple before doing this, and resets it back to full when done. This breaks the transaction log backup chain at that point, so I make sure that this is scheduled to run before my nightly full backup. It ran for the first time this Sunday, and everything went beautifully.

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply