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 state (Principal, Synchronized Expand / Collapse
Author
Message
Posted Wednesday, May 15, 2013 9:30 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, September 26, 2014 11:11 AM
Points: 143, Visits: 1,130

I have four databases (size between 20MB to 1300MB) which has (Principal, Synchronized) next to there name And on the Witness Server they have (mirror, synchronized, restoring). It's been like this for two days. I belive this happen when one of our guys took the database offline to move the Log file. What do I need to do so the (Principal ,Synchronized) state isn't there next to the database name when I look at it in Studio Management?
Post #1453181
Posted Wednesday, May 15, 2013 9:32 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 20,696, Visits: 32,330
kd11 (5/15/2013)

I have four databases (size between 20MB to 1300MB) which has (Principal, Synchronized) next to there name And on the Witness Server they have (mirror, synchronized, restoring). It's been like this for two days. I belive this happen when one of our guys took the database offline to move the Log file. What do I need to do so the (Principal ,Synchronized) state isn't there next to the database name when I look at it in Studio Management?


This is normal for mirrored databases.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1453183
Posted Wednesday, May 15, 2013 12:00 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 6:16 AM
Points: 39,953, Visits: 36,309
Why do you want to remove (Principal, Synchronised)? It's telling you that's the principal database for a mirroring configuration and that the mirroring is in the synchronised state (principal and mirror identical)


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1453248
Posted Wednesday, May 15, 2013 2:06 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, September 26, 2014 11:11 AM
Points: 143, Visits: 1,130
I wasn't sure if it was normal. When one opens Management Studio and hit database and see the list of databases names, I wasn't sure it's ok to see
DBName (Principal, Synchronized) instead of just DBName.
Post #1453267
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse