Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Log Shipping Hardware needs


Log Shipping Hardware needs

Author
Message
nick harris-294131
nick harris-294131
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 182
I am making an assumption based on a small bit of research on the subject. My goal is to set up log shipping not necessarily for failover but in the case of a localized disaster (say a fire in the server room) that my data is somewhere safe. At this point in time we are not requiring 99% uptime. I should not need a beefy piece of hardware equal to my production server because there are no active transactions occurring. I should be able to get away with a smaller server, correct?

Thank you for taking the time to read my post and answer.
Big Data Man
Big Data Man
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2210 Visits: 750
Hi,

You use whatever size server you require, but please ensure you have ample storage space on both servers and a reliable network connection between the servers for log shipping.

In addition, make sure you have a solid backup plan based on your required Recovery Time and Recovery Point Objectives.


Thanks,
Phillip Cox
Sugesh Kumar
Sugesh Kumar
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3625 Visits: 358
Also if your LS is used in DR planning see to that its able to handle the load until you get back the primary server back.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Gethyn Ellis
Gethyn Ellis
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1129 Visits: 2867
Nick,

We use logshipping for similar purposes, i.e. as an extra backup and also we use for some reporting needs.

Our secondary server is not the same spec as the primary box but it will have to accomadate your production database in terms of size and future growth. Also if you plan on using it in DR terms the secondary server will need to handle at some of your production load.

Gethyn Ellisgethynellis.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search