Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Replicated DataBase Expand / Collapse
Author
Message
Posted Monday, August 27, 2012 1:38 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 22, 2013 7:44 PM
Points: 15, Visits: 30
How do you put a replicated data base in as the primary data base?
Post #1350553
Posted Monday, August 27, 2012 2:21 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 11, 2014 3:04 PM
Points: 2,127, Visits: 747
What does that mean?


Post #1350580
Posted Tuesday, August 28, 2012 7:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 22, 2013 7:44 PM
Points: 15, Visits: 30
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.
Post #1350908
Posted Friday, August 31, 2012 4:07 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 11, 2014 3:04 PM
Points: 2,127, Visits: 747
Okay, this sounds like it is database mirroring not replication.


Post #1353111
Posted Saturday, September 01, 2012 10:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 22, 2013 7:44 PM
Points: 15, Visits: 30
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.
Post #1353148
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse