none
Project Server 2010 failover environment with Database SQL Mirroring RRS feed

  • Question

  •  

    Hello,

    We have prod and failover environment. Failover environment created by using farm backup and restore of prod.

    my question is : Can we do SQL Mirroring (from prod to failover) of 5 databases (4 PS databases and content db) to keep both the environment in sync. Will this process work in the case of Project Server 2010. i am in doubt due to timestamp and GUID in config DB.

    Also will this process is supportable.

    Any help much appreciated.

    Thanks

    Wednesday, March 26, 2014 8:23 PM

All replies

  • Hello MOhit2020,

    I haven't done this type of failover, but I think you would need to setup all your SharePoint  and project databases to use a SQL Alias to point to your production databases.  When and if your production databases failed, you would update your SQL Alias to point to the mirror location.

    The other nice feature about having SQL Alias setup in SharePoint, is that in the future, if you switch to another SQL Server, the SQL alias makes it easier to handle.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Wednesday, March 26, 2014 10:39 PM
    Moderator
  • Hi Michael, thanks

    this solution might work in the case of SQL failure but here i am talking about complete enviroment switchover in the case of failure.

    SO my question remains the same if we have two enviroments prod and Failover (created from prod farm backup restore) now if we set SQL mirroring from Prod to Failover to keep the enviroment in sync will that work or not??

    Please suggest.

    Thanks

    Thursday, March 27, 2014 8:44 AM
  • SQL mirroring is supported in SharePoint 2010/2013 and Project Server 2010/2013.

    How to setup SQL mirroring is a bit beyond a posting.

    Please see the TechNet articles here:

    http://technet.microsoft.com/en-us/library/dd207314(v=office.14).aspx

    We have deployed this technique and it works as advertised.

    Hope this helps,


    Thanks, Eric S. Pcubed

    • Proposed as answer by ErockP3 Thursday, July 10, 2014 9:41 PM
    Friday, March 28, 2014 5:00 PM