Streamlining the Database Server Recovery Process

  • Greg Larsen

    SSC-Insane

    Points: 20515

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/glarsen/streamliningtherecoveryprocess.asp

    Gregory A. Larsen, MVP

  • Klaas-Jan

    SSCrazy

    Points: 2267

    Hi Greg great article, i think it will save a lot of time. I like the concept of first building the sql before executing. I think it would be nice to have the option to only generate scripts for one database (with an optional parameter) or for all databases.

  • lge

    Old Hand

    Points: 334

    Great! I like the idea to use current msdb to create restore scripts on the spot. I suggest you include the possibility to handle several backup files for one database restore plus the possibility to MOVE files to another location.

  • Greg Larsen

    SSC-Insane

    Points: 20515

    Hey, I like the suggestions. More heads are better than one.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.com

    Gregory A. Larsen, MVP

  • localadm

    Valued Member

    Points: 53

    Greg, your approach works good in the scenario that you have put dump files in same directory where they were backed up. My suggestion is, if you can detect where they are and how many they are based on actual files, that will be great. For example, I have a DB dump and a bunch of tran log dumps in some where in harddisk. I want to restore those to a database and wish your script to generate a series of "restore" command in order. Would it be something you consider as valid request?

    Regards,

    Lin

    lintai_liu@yahoo.com

  • Greg Larsen

    SSC-Insane

    Points: 20515

    My approach reads the system tables to determine where the backups are. Now if you move the backup files to another drive then this is not recorded in the system tables, and would make it harder to write a script to find them. I suppose the script could be easily modified if you always have a specific directory in which you moved the backups, and you kept the backup name the same. Is this your case?

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.com

    Gregory A. Larsen, MVP

  • zach_john

    SSCertifiable

    Points: 5922

    Great article, should be included in any disaster recovery. What do you use to pick up the transaction log files and at what frequency?

    Cheers

    John Zacharkan


    John Zacharkan

  • Greg Larsen

    SSC-Insane

    Points: 20515

    we use veritas software to copy transaction log, full and diff backups to tape. We do this nightly.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.com

    Gregory A. Larsen, MVP

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply