Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2014-10-14 : 17:38:11
|
| I have a 2012 instance which contains some subscriber databases and some databases that are not replicated.If I include any of the subscription databases in my maintenance plan, the plan just hangs, runs forever. But if I omit the subscription databases, the plan will complete in a reasonable amount of time.The related publisher databases ARE ijncluded in the maint plan and they have no issues.Just wondering if it is advisable to include the subscriber database in the maint plan.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-14 : 17:48:44
|
| I don't use maintenance plans (I use custom scripts), but yes subscriber databases should be maintained. If the plans/jobs are hanging, then you should investigate why or use custom scripts that don't have this issue. I used to have my own custom scripts that I published on my blog but no longer have the time to support them, so we switched over to Ola's scripts: https://ola.hallengren.com/Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2014-10-20 : 19:51:47
|
| Thanks, Tara. I suspect the Maint Plan hangs when running against the subscription database because it rebuilds indexes which drops the index then recreates.I'll check out Olas' scripts. |
|
|
|
|
|
|
Running Maint Plans for a Subscription Database