SQL Server Maintenanace Plans

  • What is the consensus about using the maintenance plans to optimize your database.  I've been hearing different things concerning the maintenanace plans.  Would you prefer to use the jobs that the maintenanace plans provide (ie.. the optimization and integrity checks) or write your own scripts.

  • I wrote my own. For the simple reason that the maintenance plans are not sufficient enough. You need to create different maintenance plans for different kind of databases etc.

    I created some scheduled job's for dumping the database, dumping the logs for databases that have the 'Full' option, re-indexing the databases, checking the databases and update statistics and update usage.

    The sp's are executed by several job's, and are applied to al databases on the server. The sp's check for Full or Simple etc, so all is automated.

Viewing 2 posts - 1 through 1 (of 1 total)

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