SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Msg 3013 acting as a mirror database


Msg 3013 acting as a mirror database

Author
Message
kd11
kd11
SSC Eights!
SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)

Group: General Forum Members
Points: 815 Visits: 1535
"Database cannot be opened. It is acting as a mirror database.
Msg 3013,
Level 16,"

After restarting the principle & mirror server, my backup jobs are getting the message above.

Is there a way to get by this? Does the cache needs to be flush, do I need to wait whenever the restore/fail over is completed?

Database cannot be opened. It is acting as a mirror database.
Msg 3013,
Level 16,
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)

Group: General Forum Members
Points: 72471 Visits: 17852
what operating mode are you using for your mirror session?
do you have a witness server?

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)

Group: General Forum Members
Points: 121509 Visits: 39119
Looks like the backup jobs are running on the wrong server or your principal and mirror databses are active on the wrong servers (meaning what should be your principal database is currently acting as the mirror database just like the error message says).

Cool
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)
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)

Group: General Forum Members
Points: 72471 Visits: 17852
IMHO backup jobs should be running on the mirror, they should at least be intelligent enough to skip databases that are not online.
The mirror may not always be a dedicated mirror you may have other online databases on that instance.

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)

Group: General Forum Members
Points: 121509 Visits: 39119
Perry Whittle (6/11/2013)
IMHO backup jobs should be running on the mirror, they should at least be intelligent enough to skip databases that are not online.
The mirror may not always be a dedicated mirror you may have other online databases on that instance.


Agreed, but it is apparent that the backup(s) that are failing are failing because the database(s) are active as mirror databases not the principal database(s).

When I configured my databases to use mirroring I had processes in place to enable or disable the backup jobs as appropriate depending on the state of the databases on the servers.

The only backups that were active on both servers were the backup jobs that backed up my system databases. There were no other active user databases on my mirror servers. These were dedicated to provide HA for production databases.

Cool
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)
kd11
kd11
SSC Eights!
SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)

Group: General Forum Members
Points: 815 Visits: 1535
Yes I am using a witness server and there are other databases running on the principal which are being backup however they are not mirror like the eight that are not being backup. My witness is acting as the principal now and the principal is being the witness, thats where the backup job are located, on the witness. should I have my backup log jobs running on both Principal and witness?
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)

Group: General Forum Members
Points: 72471 Visits: 17852
You have your topology slightly skewed. The witness does not hold mirrored databases, that's the mirror instance that holds them.

The witness is a third instance that provides quorum in the event of a mirror session failure.

So, are using synchronous or asynchronous mirroring?
Do you have a witness?

The point is you can't manually fail over unless transaction safety is set to Full and the principal is online.

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
kd11
kd11
SSC Eights!
SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)

Group: General Forum Members
Points: 815 Visits: 1535
Synchronous mode and yes I'm using a witness. When querying the sys.database_mirroring on the Mirror Server it says that the mirroring_role_desc is the Principal, the mirroring_state_desc is SYNCHRONIZING and the mirroring_partner_instance is the ServerA(which was set up as the Principal)
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)

Group: General Forum Members
Points: 72471 Visits: 17852
So you've had a failover then, do you want to fail it back?

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
kd11
kd11
SSC Eights!
SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)SSC Eights! (815 reputation)

Group: General Forum Members
Points: 815 Visits: 1535
Yes I to fail it back, which I have done by restarting SQL so now my Principal Server is back to being the Principal but my backup transaction logs are not running they are get the MSG 954, database is acting as a mirror.....
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search