Painless backup on SQL 2005

Wednesday, 26 March 2008 10:27 by Myself

I found this great Backup and Maintenance script for SQL 2005 on Ola Hallengrens blog

I am no fan of Maintenance Plans in SQL Server. Even though maintenance isn't my job - I write databases - I couldn't help to be annoyed by all the backup jobs causing chaos in the Job Agent list. Every database had it's M.Plan and corresponding job. So I decided to find a better solution. One that I could feel comfortable with.

Moving the entire backup plan to this script will make it much more sustainable. I am going to test it this week.

Related posts

Add comment


(Will show your Gravatar icon)  

  Country flag

[b][/b] - [i][/i] - [u][/u]- [quote][/quote]



Live preview

November 22. 2008 04:26

 
Software