Follow Me
« Managing Dynamics GP without using sa login | Main | Talking about Installing Dynamics GP 10.0 with .Net 2.0 SP1 »
Tuesday
Sep232008

Changing method of database maintenance

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:

 

http://ola.hallengren.com

 

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. 

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.