[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

SQL 2005 warm site replication with log shipping

One more question - log shipping looks like it will work for us - do you have any additional incite or pitfalls of log shipping?

Thanks
0
JohnMac328
Asked:
JohnMac328
  • 2
2 Solutions
 
MrAliCommented:
Log shipping is very straight fwd and one of the easiest ones to administer so not really many pitfalls.  Just make sure you don't have any other jobs making transaction log backups on the database(s) being log shipped over.  The server being log shipped to will go into a 'recovery' mode based on the interval you set (probably every 15 mins default) which means all users are kicked out as it restores the latest transaction log file.  If you ever need to fail over to the warm standby server just make sure the latest transaction logs are applied which you can see in the monitor or by doing a 'restore database' command yourself so that you have maximum data retention.  Let us know if you have any questions!
0
 
MrAliCommented:
just a heads up, this video should suffice.  I'd recommend playing with Log Shipping once you got it up and running to figure out what to do in a 'OH $H1T!' moment when you need to bring the DB online and make the app see it as well.  That way you're not doing it for the first time when your feet are on the fire :)

http://youtu.be/TLvoDjTs8bo
0
 
skaraiCommented:
The respective DB being log shipped  (not the server) will be unavailable during the time the log is applied on the receiving server which can be a problem is the log backups are large and the the time it takes for log applies start to exceed your availbility goal window. Monitroing your log backup sizes and adjusting log backup windows is a tuning task over time.
0
 
JohnMac328Author Commented:
Thanks all - more great information
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now