Home Forums SQL Server 2005 Backups Restore multiple Differential backups RE: Restore multiple Differential backups

  • April 2, 2009 at 7:58 am

    #970706

    GilaMonster (4/2/2009)

    To restore more backups the database has to be in norecovery, which means it's not readable. Diff backups aren't really suitable for keeping a test server up to date. Have you considered replication?

    I cannot setup replication as the production database is not in my control.

    Can you provide a script to restore all differential backs hour after hour?

    Also, can this be achieved by the SQL Management Console itself?

    Thanks for all your help 🙂

    [font="Verdana"]
    -------------------------------------
    Anukul
    My Blog
    My Twitter Profile
    My Stumbles[/url]
    [/font]