2nd Server min requirements for transaction log shipping

  • laptoptitan

    SSC Rookie

    Points: 37

    I will have a 64-bit 2008 R2 SQL Server Standard edition acting as the production (primary) database server in a vSphere environment.

    I was planning on creating a secondary server that mirrors the Operating system environment and SQL server configuration, which is where the primary databases transactional logs will be shipped and applied.

    Since this is a virtualized environment the plan was to keep the secondary server to a bare minimum in terms of CPUs/RAM, but I am wondering what the bare minimum recommendation here would be.

    I am also wondering how what the most effective licensing model would be for the secondary server, since technically it is only a standby server, it wont have any active user connections other than whats necessary for shipping and applying the transactional logs.

    Any info/experience would be much appreciated!

  • Mr. Brian Gale


    Points: 23055

    My opinion (experts correct me if I am off on this) - the "secondary" server when doing log shipping is usually in place for disaster recovery.  If the primary server tanks itself for some reason, you want this secondary to pick up the slack.

    Due to that, my recommendation would be to make sure it has the SAME resources available than the primary.

    Now, the "bare minimum" for the secondary would likely be the bare minimum for SQL Server 2008 R2, but as soon as this secondary needs to become the primary, you are going to regret using the bare minimum.

    As for the licensing model, if you have software assurance, then the secondary is free (I believe?  Not sure if that applies to 2008 R2 or not).  But that is a VERY loaded question.  Does your primary use features of Enterprise edition?  then the secondary should be on that version too.  if your databases are small (under 10 GB) you may be able to get by with express (NOTE - not sure it supports log shipping).

    For licensing questions, I strongly encourage you to reach out to your SQL Server licensing vendor as they may be able to get some deal for you and WILL be able to provide you better advice than the forum will.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720426

    Secondary, bare minimum + disk space needed for log backup + database size (+pad).

    Licensing is weird. I don't think this is allowed, but I don't have 2008 R2 licensing handy. Typically you need to license a secondary without software assurance, but no idea about that old a version.



Viewing 3 posts - 1 through 3 (of 3 total)

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