Testing SQL Replication
Hello Experts
I have a client that has 2 2008 R2 servers both running SQL 2008 R2 and are setup to do SQL transactional replication. I am fairly limited in my SQL knowledge and would like someone to help me determine if the replication is taking place and also to figure out what I would need to do in the case that the main server was to go down to get them going again.
I know this is a rather large task but I need to get this documented in case they go down and I would rather do in advance so we can have a recovery plan.
One other thing the subscriber is running in a Hyper-v enviroment and the Publisher is on a physical machine but they are two seperate physical serves.
I am sure you need more info than i have provide so just ask and I will get it ASAP.
Thank You
Don
I have a client that has 2 2008 R2 servers both running SQL 2008 R2 and are setup to do SQL transactional replication. I am fairly limited in my SQL knowledge and would like someone to help me determine if the replication is taking place and also to figure out what I would need to do in the case that the main server was to go down to get them going again.
I know this is a rather large task but I need to get this documented in case they go down and I would rather do in advance so we can have a recovery plan.
One other thing the subscriber is running in a Hyper-v enviroment and the Publisher is on a physical machine but they are two seperate physical serves.
I am sure you need more info than i have provide so just ask and I will get it ASAP.
Thank You
Don
ASKER
Thanks for the reply Jagdish
Sorry but my SQL skills are not very good.
I tried copying and pasting the query in the SQL query window in the 2nd and 3rd link but it just gave me a debugging message on the 2nd link for several minutes and an error on the 3rd link.
Can you please explain what I need to do prior to running these queries to insure they work.
Thanks Again
Don
Sorry but my SQL skills are not very good.
I tried copying and pasting the query in the SQL query window in the 2nd and 3rd link but it just gave me a debugging message on the 2nd link for several minutes and an error on the 3rd link.
Can you please explain what I need to do prior to running these queries to insure they work.
Thanks Again
Don
Open sql management studio and connect to your sql server ..
expand the replacation tab ..
You will see publisher and subscriber folders as shown in attachment
open publisher .. if there is anything in there this is your publications
open subscriptions .. if there is anything in there this is your subscriptions
if both are empty then you server is not participating in replication
repl.JPG
expand the replacation tab ..
You will see publisher and subscriber folders as shown in attachment
open publisher .. if there is anything in there this is your publications
open subscriptions .. if there is anything in there this is your subscriptions
if both are empty then you server is not participating in replication
repl.JPG
ASKER
Thanks for the reply tab8 and yes I can see the publication and subcription so I believe it is working but I would like to test it to see what needs to be done in case the main server goes down. Would we simply rename the subscriber server and change its IP to match the publisher server?
Don
Don
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks Tab8 that is what I was loking for.
Please check the following links to solve your query:
http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/2298c4b8-6b5b-454d-ba8a-6ce68d270a0a
http://stackoverflow.com/questions/220340/how-do-i-check-sql-replication-status-via-t-sql - Using Qury
http://www.databasejournal.com/img/ReplicationValidation.txt
Bye.