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

Database mirroring error in sql server 2008 Expand / Collapse
Author
Message
Posted Thursday, October 15, 2009 10:44 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, February 01, 2011 3:13 AM
Points: 139, Visits: 282
Hi all,

While configuration database mirror in SQL server 2008 i am gettting the below error

Database mirroring cannot be enabled because the database is read only on one of the partners.

i have restored the secondary database is in standy by mode currently for mirroring.

If i restore in secondary database in Norecovery mode i am getting the below error

Database mirroring cannot be enabled because the database is in middle of the restore only on one of the partners.

So please guys help me to fix this issue.

Post #803597
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse