Home > SQL server DBA administration > Maintenace plan advange and disadvantage

Maintenace plan advange and disadvantage


Maintenance Plans give DBAs an easy way to run database maintenance procedures. With Maintenance Plans, you can run database backups, transaction log backups, index rebuilds, stats rebuilds, database consistency checks and shrink a database. There’s no shame in using maintenance plans for backups if they suit your needs. Maintenance plans are great for those who can’t customize something better. I prefer scripts, because they can be customized to your specific DR needs.

A weakness with them is they do not failover at all well in HA\DR solutions that involve a server name change. In that case scripts are better unless you are prepared to maintain two versions of the maintenance plan, one on each server in the DR pair. Scripts will give us more flexibility than maintenance plan. Also when you upgrade/migrate your database, scripts will not give you that much problem as Maintenance Plan do.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: