Hi Everyone,

I bought LiteSpeed Backup, I am using it for SQL 2000 Server. Interesting thing is some function are similar with SQL 2005 maintenance plan.

However, let me get to the point...

I setup 3 difference maintenance plan in Litespeed - Please analyse and suggest me if I am doing something wrong

Mon-Fri

1.Check DB Integrity [All Database]

2.Shrink Database [Expect System Database]

3.Backup Database [All Database]

4.Clean Up Maintenance Plan

5.Clean Up History

Sat

1.Check DB Integrity [All Database]

2.Rebuild Index [Expect System Database]

3.Shrink Database [Expect System Database]

4.Backup Database [All Database]

5.Clean Up Maintenance Plan

6.Clean Up History

Sun

1.Check DB Integrity [All Database]

2.Reorganise Index [Expect System Database]

3.Shrink Database [Expect System Database]

4.Backup Database [All Database]

5.Clean Up Maintenance Plan

6.Clean Up History

Other Reason I am doing 'Rebuild' and 'Reorganise' on difference day becasue it take long time to index and another reason is-

Reorganise an index when the degree of fragmentation is between 5 and 30%

Rebuild an index when the degree of fragmentation is over 30%

Is that right setup?

Thanks.

Leo