August 27, 2012 at 1:38 pm
How do you put a replicated data base in as the primary data base?
August 27, 2012 at 2:21 pm
What does that mean?
August 28, 2012 at 7:17 am
We have a new client. Their primary computer was acting a the "master database". Their secondary server was hosting the replicated data base. The primary server went down. We needed to know how to turn off the replication process. We did discover the ALTER DATABASE SET PARTNER OFF command for the replicated data base but then they went into "Database (restoring...)" mode and in 12 hours have not come out of that mode. So we managed to get a copy of the original data base off of the primary server and copied that to a new server and now we are using the primary database in a different environment. Is there another command to tell the "master data base" that there is no longer a "PARTNER" also? The primary server is running fine until we turn on SQL and then it is a dog. We think this is a SQL issue and not hardware as we originally expected.
August 31, 2012 at 4:07 pm
Okay, this sounds like it is database mirroring not replication.
September 1, 2012 at 10:52 am
Thank you for clarifying. We seem to be up and running again on a replacement computer. We did find out that the previous partner had imbedded virtual servers within virtual servers. What a mess. This SQL server is running in a buried virtual server and there is another virtural server running Exchange inside a virtual small business server. We are untangling it now.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply