September 4, 2012 at 3:46 am
Hi,
Finally sucssfully configured database mirroring with no errors. For High safty with manual failover method...
Principal has been synchronized with Mirror server.
Launch look at Mirror monitor
---------------------
Time Recorded - every 1 minites, Is it default time? can we change this time. if change that what will impact for both servers?
thanks
ananda
September 6, 2012 at 12:15 am
It's just a SQL job that runs. If you want to change the run time, edit the SQL job to run a different frequency. The performance impact is negligible.
September 6, 2012 at 12:19 am
Hi Anand,
Robert is right, change it into run time and one more plus point is incase your Principal server will crash or else updated data will get in mirror database..
Satish
September 6, 2012 at 12:26 am
saidapurs (9/6/2012)
Hi Anand,Robert is right, change it into run time and one more plus point is incase your Principal server will crash or else updated data will get in mirror database..
Satish
I'm not sure I understood your 2nd point correctly, but the database mirroring monitor job has no affect on how quickly data makes it to the mirror database. Transfer of transactions happens continuously no matter what you set the monitor job to do.
September 6, 2012 at 12:32 am
ok, thanks for reply
By default running every 1 mintes mirror monitoring job for both principal and mirror server database, so if change these job run time every 30 minits jobs history will be reduced.
please tell me, where monitoring mirror job history stored? at MSDB or same principal, mirror database itself.
Can we delete the mirror jobs history manually? monthly or weekly basis.
or let it be leave that?
thanks
ananda
September 6, 2012 at 12:42 am
History is stored in msdb database in msdb.dbo.dbm_monitor_data. You don't need to delete the history. The monitor job will take care of that for you.
September 6, 2012 at 1:12 am
Thank you again for more details given me about mirroring
I want ask some question about database mirroring part.
1. Mirroring configured both principal and mirror server by same domain account1, now mirroring is working fine there is no issues...
If changed another domain account2 at sql service account, SQL Engine service will be working then what will happend at Mirroring part for both server? In this cause, Does we need to reconfigure mirroring?
2. whenever principal server not available, then need to fire the command at Mirror server, pl. confirm the below query is correct steps.
Now both server are working with partner.
1. ALTER DATABASE <database name> SET PARTNER OFF
2. ALTER DATABASE <database name> SET PARTNER FAILOVER
3. RESTORE DATABASE <database name> WITH RECOVERY
3. During configuration stage, I have enter same domain account at specify login account field for connect principal & mirror server. If we are using same domain account for both server no need to enter login account these two filed, Is it correct?
4. Mirroring configured with manual failover, not using wittness server and HIGH SAFTY mode sychronized option. In this senario, does mantatory using Quouram vloume or not required? I am using physical HD only...
thanks
ananda
September 6, 2012 at 1:17 am
ananda.murugesan (9/6/2012)
If changed another domain account2 at sql service account, SQL Engine service will be working then what will happend at Mirroring part for both server? In this cause, Does we need to reconfigure mirroring?
Just grant the new account connect permissions to the mirroring endpoint
ananda.murugesan (9/6/2012)
2. whenever principal server not available, then need to fire the command at Mirror server, pl. confirm the below query is correct steps.Now both server are working with partner.
1. ALTER DATABASE <database name> SET PARTNER OFF2. ALTER DATABASE <database name> SET PARTNER FAILOVER
3. RESTORE DATABASE <database name> WITH RECOVERY
What are you expecting the restore with recovery to do, which database is it targeted at?
ananda.murugesan (9/6/2012)
3. During configuration stage, I have enter same domain account at specify login account field for connect principal & mirror server. If we are using same domain account for both server no need to enter login account these two filed, Is it correct?
its been a while since i used the GUI but yes i'm sure that it says if the account is the same leave it blank
ananda.murugesan (9/6/2012)
4. Mirroring configured with manual failover, not using wittness server and HIGH SAFTY mode sychronized option. In this senario, does mantatory using Quouram vloume or not required? I am using physical HD only...thanks
ananda
Quorum is for failover clusters. In mirroring the witness provides your quorum.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:35 am
Thanks for reply..
In second question, Mirror database not read to use an application level during the mirroring session, when principal database goes down? how can up mirror database for application side? which commands need to execute at mirror server?
September 6, 2012 at 1:41 am
To manually fail to the mirror you need to execute
ALTER DATABASE <database name> SET PARTNER FAILOVER
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 3:07 am
Thank you for cleared all my doubts..
Is there Free Tools for monitoring Database Mirroring session? not in SSMS Launch Mirror Monitor
September 6, 2012 at 3:46 am
Mr. Perry Whittle, one final question
1. What is the best pratices & procedure restarted both server principal & Mirror? if restart required.
Pl.confirm
Do we can normal restart method followed or any spacial steps need to be followed if Database Mirroring configured? after restart unsend log will be transfer to mirror server from principal server once reconnect both server also mirroring session will be automatically started & synchronized.
September 6, 2012 at 4:03 am
ananda.murugesan (9/6/2012)
Mr. Perry Whittle, one final question1. What is the best pratices & procedure restarted both server principal & Mirror? if restart required.
Depends, are you rebooting both at sametime or at different times of the day.
If your session is high safety with auto failover i would remove the witness whilst the maintenance\reboots are carried out. Check Books Online, it gives you all the info you need for these scenarios
ananda.murugesan (9/6/2012)
Do we can normal restart method followed or any spacial steps need to be followed if Database Mirroring configured? after restart unsend log will be transfer to mirror server from principal server once reconnect both server also mirroring session will be automatically started & synchronized.
If you reboot the mirror the principal will be marked as disconnected and log records will be retained in the principal log file, once the mirror comes back online the log records will be sent to the mirror and will be marked as synchronising. The status will eventually be marked as synchronised once all log records are committed.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply