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.