If i reboot primary server first ? (it will move to secondary), and then secondary (it will again move to primary)

there is no error massage, when login it is stuck on "apply user setting".

but my question here is to understand reboot process in this scnerio.
and what is...

there are 3 server 
1-primary 2 -secondary 3-secondary.
1 and 2 are not accessible due to some windows issue

can you tell me implications of both synchronous and asynchronous?

but in my production environment i have 4 DBs ... in which 3 DBs are publisher and one is subscriber.. all 3 DBs are replicating some of their objects in...

its a nice article but still not answering my query, whether replication will continue after failover or if on the same instnace publisher , distributor and subscriber will be kept.

thanks for the reply, but bigger challange for now seems to sync both the DB to make them strict subset. currrrenty few objects are there on DB1 which does not...

Thanks for the reply, when we define post initialization script, it runs only on subscribers, what if i want to run few permission related script in publisher only?

last time i have excecuted it by removing one (") quote, thought its a multiple " quote issue. and script is executing since yesterday it was not even getting...

i printed the Tsql fron @cmddtring variable which is actually getting executed at last, kindly find the printed or actual executed text of @cmdstring below, i have not added any...

actually i am quite new on this powershell scripting, it seems quite complex on this stage. so i have got following script and modified in my ways replaced hours in...

i have posted in two forums because i am expecting it can be either done through powershell or tsql.

hi,

maintainenace plan itself uses internally same SP "XP_delete_file", i tried using XP_cmdshell 'forefile...

but it does not facilitate to provide time or hours... only days can be defined.

how to define time...

how do we confirm whether lock pages enabled or not. does It require server reboot. after adding service account in administrator group.

hi Anthony,

can you please describe about OU and GPO as i am not aware about it,

i already configured AWE enable and max server memory to 24 GB, i dont...