Solved

Database Maintenance Plan and Replication

Posted on 2004-03-31
2
453 Views
Last Modified: 2008-07-03
I am having trouble finding out what way Replication affects a Database Maintenance Plan.

I have SQL SERVER 2000 publisher to a few MSDE pull subscriptions (merge replication).  I would like to scehdule optimization and integrity checks, but I am not sure how replication will affect this task.  How will the db checks affect my replicated environment?  With replication in place, does this mean I must schedule a similar plan for each replica?

Thanks in advance


0
Comment
Question by:youngrascal
2 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 200 total points
ID: 10726916
As long as you don't change the schema on your underlying database, you can still defrag indexes and backup like normal.  As far as setting up maint plans on your replicated clients--the same thing applies....
0
 

Author Comment

by:youngrascal
ID: 10744798
Thanks arbert,

Ok so Checking and Rebuilding indexes will not affect or be affected by replication.  

The logs generated indicate that the indexes are being rebuilt.
So then what is it that is being changed by an integrity check at each replica?  I guess what I'm looking for is if you could confirm the notion that indexes are not included in replication.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now