November 21, 2012 at 2:13 am
Dear,
I have implemented database mirroring with automatic failover option. My principal database is a busy one. Now I am not sure that whether the mirror database is receiving data from principal.
How do I check that ?
Please help me.
Regards,
Akbar
November 21, 2012 at 2:41 am
Mirrored database can't be accessed at any time. You need to take a Snapshot of mirrored database, then you can query the snapshot (Snapshot option is in only Enterprise Edition).
Also if you use the Mirroring Monitor (in ssms), you can identify whether you mirroring session in sync.
November 21, 2012 at 4:06 am
Actually I am using Standard Edition, so can not create database snapshot.
I went database mirroring monitor and found "Synchronized" from Mirroring State column of both of the server instances.
Does it indicate that data is updated from principal to mirror?
November 21, 2012 at 4:20 am
shohelr2003 (11/21/2012)
I went database mirroring monitor and found "Synchronized" from Mirroring State column of both of the server instances.
this would be the first assured and positive impression that data is being mirrored
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 21, 2012 at 4:47 am
Thank you, so nothing to be worried.
November 21, 2012 at 5:52 am
shohelr2003 (11/21/2012)
Thank you, so nothing to be worried.
You should also see next to the principal db says "synchronized"
Since you have witness server, I am thinking, you configured with synchronize mode.
Regards,
SueTons.
Regards,
SQLisAwe5oMe.
November 21, 2012 at 7:46 am
SQLCrazyCertified (11/21/2012)
shohelr2003 (11/21/2012)
Thank you, so nothing to be worried.You should also see next to the principal db says "synchronized"
Since you have witness server, I am thinking, you configured with synchronize mode.
Regards,
SueTons.
With Standard edition, synchronous is the only option available.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2012 at 7:49 am
Ohk....thanks Perry.....didn't know that.
SueTons.
Regards,
SQLisAwe5oMe.
November 21, 2012 at 10:05 am
SQLCrazyCertified (11/21/2012)
Ohk....thanks Perry.....didn't know that.SueTons.
Standard only supports full safety, this translates into synchronous mode
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2012 at 9:11 pm
If I restore database on principal, then what steps should be taken to maintain mirroring? Do I need to do anything on mirror database?
Please help me.
November 22, 2012 at 1:45 am
Assuming that you want to restore a copy of the database over the live principle database, you will have to break the mirror first and then set it back up again after the restore.
November 22, 2012 at 2:54 am
For mirroring, I have gone through the following steps.
1. backed up database from principal
2. backed up transaction log from principal
3. restored database to the mirror with no recovery option
4. restored transaction log to the mirror with no recovery option
5. at last configured mirroring
Now my question is if I restore a database to principal, should I go through the above mentioned steps? Or there are any alternate solution?
November 22, 2012 at 11:04 pm
shohelr2003 (11/22/2012)
Now my question is if I restore a database to principal, should I go through the above mentioned steps? Or there are any alternate solution?
alternative option means ???? yes you can use wizard too
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 23, 2012 at 9:49 am
Actually I can not clarify myself.
Say, I configured mirroring on 10 November. That means I backed up database and log from principal and restored to mirror with no recovery on 10 Nov.
Now for some reason I wanna restore database to my principal from another databse.
Will it cause any inconsistency in mirror databse? Or may I need restore database and log backup from that another database to mirror database?
November 25, 2012 at 10:53 pm
shohelr2003 (11/23/2012)
Now for some reason I wanna restore database to my principal from another databse.Will it cause any inconsistency in mirror databse? Or may I need restore database and log backup from that another database to mirror database?
to restore any backup to mirrored database , you need to break the mirroring so when u break mirroring and restore new backup on principal server then it will replicate the server on second server when u again re-setup the mirroring
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply