SQL 2005 warm site replication with log shipping

Posted on 2011-10-27
Last Modified: 2012-05-12
One more question - log shipping looks like it will work for us - do you have any additional incite or pitfalls of log shipping?

Question by:JohnMac328
    LVL 7

    Accepted Solution

    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!
    LVL 7

    Expert Comment

    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 :)
    LVL 7

    Assisted Solution

    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.

    Author Closing Comment

    Thanks all - more great information

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now