locked
Mirror on 2nd server RRS feed

  • Question

  • We run an inventory management and order management software on a Dell server that runs win 2008.

    It runs 24/7/365 and uses SQL for the database.  Everything is located on the one server.  The database and the software.

    About 30 people connect to it all day and about 5 at night along with constant streams of multiple API connections all day and night.

    output is 5gb per day and input is 2gb per day.

    It has yet to happen but if the server breaks, goes down etc our entire company will go down.  We have a constant backup running so we can get up and running without losing data but we would be down until we can either get a new server in or fix the server.

    I want to somehow have something always running and duplicating the current server so if that goes down everything switches over to the backup server like a RAID 1 would do for a HDD.

    Lets say the MB dies on the server it shoudl switch over to server 2 that already has the exact same data on there and we would have no down time.

    I know it is simply database mirroring but can we benefit from the 2nd server while it is just being used as a live backup similar to striping hard drives?  Have the 2nd server not only be a mirror but also share the load of the main server.


    • Edited by D2-Danny Thursday, February 13, 2014 1:24 AM add to the question
    Thursday, February 13, 2014 12:55 AM

Answers

  • Would a SAN or NAS be a better solution to work with a server cluster? We would get 3 servers to work with the storage array.
    Clustering wont be a complete solution here.You can ofcourse use clustering as OS redundancy but for database redundancy you will have to configure Mirroring or transaction log shipping for database in cluster.Combination of both miroring or transaction log shipping with clustering will provide you desired solution which you require.

    Regarding SAN and NAS, SAN would be a good option preferrably with RAID10 or RAID 5

    If you have 2012 you can go for Always ON

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Marked as answer by tracycai Tuesday, February 18, 2014 8:08 AM
    • Edited by Shanky_621MVP Thursday, March 6, 2014 3:33 PM
    Thursday, February 13, 2014 8:09 PM

All replies

  • If you have many critical databases I would suggest going for the clustering where  you are protected on the instance level.

    Please read this article to see what feature suits you.

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

    >>>I want to somehow have something always running and duplicating the current server so if that goes down >>>everything switches over to the backup server like a RAID 1 would do for a HDD.

    1.Mirroring

    2. Replication


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Proposed as answer by tracycai Thursday, February 13, 2014 9:43 AM
    Thursday, February 13, 2014 5:52 AM
  • Would a SAN or NAS be a better solution to work with a server cluster? We would get 3 servers to work with the storage array.
    Thursday, February 13, 2014 6:56 PM
  • Would a SAN or NAS be a better solution to work with a server cluster? We would get 3 servers to work with the storage array.
    Clustering wont be a complete solution here.You can ofcourse use clustering as OS redundancy but for database redundancy you will have to configure Mirroring or transaction log shipping for database in cluster.Combination of both miroring or transaction log shipping with clustering will provide you desired solution which you require.

    Regarding SAN and NAS, SAN would be a good option preferrably with RAID10 or RAID 5

    If you have 2012 you can go for Always ON

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Marked as answer by tracycai Tuesday, February 18, 2014 8:08 AM
    • Edited by Shanky_621MVP Thursday, March 6, 2014 3:33 PM
    Thursday, February 13, 2014 8:09 PM