SQL Server Replicated DataBase

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server Replicated DataBase

SQL Server Replicated DataBase

Rate Topic

Display Mode

Topic Options

Author

Message

jean 93062

Posted Monday, August 27, 2012 1:38 PM

Grasshopper

Group: General Forum Members
Last Login: Saturday, May 11, 2013 12:07 PM
Points: 14, Visits: 23

How do you put a replicated data base in as the primary data base?

Post #1350553

andersg98

Posted Monday, August 27, 2012 2:21 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 6:56 PM
Points: 2,118, Visits: 731

What does that mean?

Post #1350580

jean 93062

Posted Tuesday, August 28, 2012 7:17 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, May 11, 2013 12:07 PM
Points: 14, Visits: 23

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

andersg98

Posted Friday, August 31, 2012 4:07 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 6:56 PM
Points: 2,118, Visits: 731

Okay, this sounds like it is database mirroring not replication.

Post #1353111

jean 93062

Posted Saturday, September 01, 2012 10:52 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, May 11, 2013 12:07 PM
Points: 14, Visits: 23

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 »

Permissions