Post reply

SQL Server 2008 mirrored Database with manual failover, now need reporting database.

  • October 10, 2012 at 4:17 am

    #282985

    Hi

    Our current setup is a principal database used in production with a manual failover mirrored database for HA.

    I need to setup a reporting database as well. What would be the best approach? Shall I setup a SQL job to drop and create the snapshot of the mirrored Database and refresh this every night?

    Does anyone have any other suggestions?

    Thanks D

  • October 10, 2012 at 4:48 am

    #1547581

    Which version\edition of SQL Server are you using?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • October 10, 2012 at 4:52 am

    #1547583

    2008, I know in 2012 mirroring has been enhanced to allow read copies.

  • October 10, 2012 at 4:55 am

    #1547585

    d.curtin (10/10/2012)

    2008

    Standard, Enterprise, Web, workgroup, Developer, Express.....

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • October 10, 2012 at 5:54 am

    #1547604

    Oh sorry, enterprise

  • October 10, 2012 at 6:57 am

    #1547632

    Also asked here: http://dba.stackexchange.com/questions/25730/sql-server-2008-mirrored-database-with-manual-failover-need-reporting-database/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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