How to check mirrored database

  • 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

  • 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.

  • 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?

  • 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;-)

  • Thank you, so nothing to be worried.

  • 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.

  • 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" 😉

  • Ohk....thanks Perry.....didn't know that.

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • 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" 😉

  • 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.

  • 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.

  • 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?

  • 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;-)

  • 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?

  • 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