I'm just getting back into SQL Server after a hiatus since 2002, and need some guidance on constructing a maintenance plan for a clients SQL Server.
They currently have a Maintenance Plan that looks like the attached.
But it looks to me like they are shrinking the database before backing it up. Lets just assume, for the time being that their backup frequency (2 days) is about right. Should they be doing the backup before or after the Shrink Database task
As I recall from my days using 2000, there was an issue regarding the growth of transaction logs. I believe we had to manually shrink those logs after we backed up the database. Do you still have do to that? I don't see a tasks for doing that in the Maintenance Plan Tasks list. Can you add that task to the script?
I also understand that Shrinking the database can damage index files. Do I need to add a Rebuild or Reorganize Index Task to the plan.
Any other steps I'm missing for a database maintenance plan?