Hi Robert Davis,

I am novice on sql server mirroring. I need to know how I can switch the mirroring mode to asynchronous (high performance) for index maintenance as per your...

Thanks Charles.

If any sp is executed at publisher then some logs would traverse through the distributor to subscriber. Would log contain the information of SP execution or execution of statements...

Do you mean that inactivity_threshold is set only for distribution agent. Is this not set for log reader agent.

How to changed the value of inactivity_threshold using GUI?

-lk

But MSzI,

My question is something else.

How to change the Inactivity Threshold for any agent in sql2k5?

-Lk

Oh thanks

Charles and Roy,

I have two small questions for you. These answers are very important for me.

Qu: 1:If alter command is replicated then any schema change would not require any reinitialization...

When we need to make any schema change then we can issue ALTER command in the publisher and this should get replicated to subscriber. Is this not correct?

What exactly happens...

Yes resource DB gets updated automatically when serivce packs are applied. But along with resource DB there are many other .dll files which get udpated.

Thanks Gila.

Hi GR and Gilla,

Could you go through following article where I found these statements under the heading of 'Advantages of Resource db'.

http://www.sql-server-performance.com/articles/dba/Importance_of_the_Resource_Database%20_p1.aspx

Could anyone go through them and tell...

Seems to b a nice technique.

The basic concept suggested by Vinay is as follows:

The log reader agent should run when the first snap shot is created. This helps replicating the changes happened at the time...

Can we think of creating publication for these 300 articles at Subscriber B? As 1000 tables are published from publisher so there is too much load on publisher. I am...

Hi Sanjiv,

You will be creating many combinations (all possible combination) to create many publications for the articles. This would cause too much load on every piece of the replication. Could...

Roy,

Don't we need to reinitialize the subscription if we need to alter the schema? I am not sure.

Lk