Solved

Database Maintenance Plan and Replication

Posted on 2004-03-31
2
455 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

777 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