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

how to enable back database mirroring Expand / Collapse
Author
Message
Posted Monday, April 8, 2013 8:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 29, 2013 2:17 AM
Points: 8, Visits: 41
Hi Everyone,

I Have disabled database mirroring on principal server using below command for restoring database over a mirrored database because it was not allowing me to restore.

ALTER DATABASE AdventureWorks2012 SET PARTNER OFF;

after executing above command i was able to restore the database , now i want to enable back database mirroring
can some please help me with the steps.

Thank you in advance for looking into my post.


Post #1440118
Posted Monday, April 8, 2013 11:45 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:44 AM
Points: 66, Visits: 437
The database and log of the principle database needs to be backed up and restored on the mirrored instance to get them in sync. Only then can the mirrored session be re-established.
Post #1440151
Posted Wednesday, April 10, 2013 1:29 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 31, 2014 7:48 PM
Points: 119, Visits: 494
Restore latest Full backup first and Transaction Log backup with RESTORE WITH NORECOVERY option (db should be in restoring mode).
Then, start configuring DB Mirroring again.

Hope this helps..!


Cheers,
- Win
"Dont Judge a Book by its Cover"
Post #1440679
Posted Wednesday, April 10, 2013 5:32 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:23 AM
Points: 5,886, Visits: 13,047
here is a link to a set of instructions - http://www.mssqltips.com/sqlservertip/2464/configure-sql-server-database-mirroring-using-ssms/

before setting it up though read up on the various operating modes and decide which you want and wether you will be using a witness server.

I would suggest using the SQL service account to connect as well rather than sa.

When setting it up script the set up out from the gui.


---------------------------------------------------------------------

Post #1440741
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse