Post reply

how read from mirror server ?

  • February 25, 2013 at 2:14 pm

    #270791

    Hi all,

    I have a production server with 3000 online users,

    I set up SQL server database mirroring,

    Now I want to reduce load of database by :

    1: connect main users to principal database (500 users).

    2: connect other users to mirror database (2500 users who just view the reports of application)

    how can I read data from mirror database for fetch reports?

    Shall I use log shipping ?

    Any ideas ?

  • February 25, 2013 at 2:18 pm

    #1590941

    Take a snapshot of the mirror, and have the users connect to the snapshot:

    http://technet.microsoft.com/en-us/library/ms175511.aspx

  • March 5, 2013 at 12:17 pm

    #1593603

    if you plan to make use of snapshot, do remember its static and will have data upto point in time when snapshot is created....

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • March 7, 2013 at 3:19 am

    #1594365

    Hi

    You have 2 options to perform..

    1) Go for Database Snapshot & update snapshot frequently...

    2) Go for Merge (Peer to Peer) replication for enabling mulitple users to update the data & merge it finally...

  • March 7, 2013 at 6:32 am

    #1594416

    balaji.it02 (3/7/2013)

    Hi

    You have 2 options to perform..

    1) Go for Database Snapshot & update snapshot frequently...

    2) Go for Merge (Peer to Peer) replication for enabling mulitple users to update the data & merge it finally...

    The OP mentioned that the secondary group was for reporting only. Why complicate things exponentially by bringing merge replication into the mix? What is the advantage to that?

  • March 7, 2013 at 7:59 am

    #1594469

    Saber_Talas,

    Snapshot is available in Enterprise edition only. If You have it, you can go ahead with snapshot.

    Log shipping (with Standby mode) will you give more convenience than snapshot. But the problem is log restore and user connection are not mutally compatible, ie, user cant connect to database while restore happens or vice-versa. So you will need to balance in timing of these two activities.

  • March 7, 2013 at 11:37 am

    #1594619

    How close are you to upgrading to 2012?

    AlwaysOn can allow a secondary replica to accept read-only connections.


    Check Your SQL Servers Quickly and Easily
    www.sqlcopilot.com

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply