Restore Primary Database From Log Shipping TRN Files?

Posted on 2008-11-05
Last Modified: 2008-11-06
Hello, we are looking for a way to back up transaction logs on an hourly basis and have them moved to a different location after completed (to save disc space on the Primary server). We are considering Log Shipping. Is it possible to use the Log Shipping files to restore the PRIMARY database in event of disaster? We would not set up a stand-by, SECONDARY server, instead we would just use Log Shipping as a mode to make TRN backups and move them to another server for storage. Can someone tell me if this is possible/not recommended/provide explanation?

Question by:CBF-IT
    LVL 5

    Expert Comment

    Hi, I would suggest database mirroring instead of log shipping. Much better and safe.
    LVL 15

    Accepted Solution

    Yes, it is can move them to free up some space but make sure you test your backups frequently don't wait until the day of restore for recovery of failed primary server...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    779 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

    13 Experts available now in Live!

    Get 1:1 Help Now