Tuesday
Sep232008
Changing method of database maintenance
Tuesday, September 23, 2008 at 11:25AM I’ve always used the Maintenance Plans when configuring backups and maintenance routines on SQL Server, since it was easy to understand and change the properties of the jobs.
However I like the idea of configuring backup and maintenance with a reusable script that will keep maintenance consistent between my SQL customers, such as this one:
I should be able to start with this and tweak it to my liking, then use this at each customer instead of setting up maintenance plans from scratch at each customer site.
Andy |
Post a Comment | tagged
Backup,
Maintenance,
SQL Server
Backup,
Maintenance,
SQL Server
Reader Comments