Post reply

Automate Restore 1

  • October 27, 2010 at 9:24 pm

    #228447

    Can someone write an article that shows how to read a backup file, get the logical file names/locations, and then perform a restore?

    Custom config to change the dbname, the folder paths would be nice.

  • October 28, 2010 at 1:33 am

    #1243373

    I'll take this one.

    blog: http://sarveshsingh.comTwitter: @sarveshsing

  • January 18, 2011 at 9:10 pm

    #1275086

    Steve, has this one been committed? If not, I have something for this one.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 19, 2011 at 6:46 am

    #1275270

    And I could do one on auto restores to another instance / server. If you wanted something that comes after the basic.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 19, 2011 at 7:39 am

    #1275310

    Brandie Tarvin (1/19/2011)

    And I could do one on auto restores to another instance / server. If you wanted something that comes after the basic.

    I wonder how similar our methods may/may not be. The method I use (nightly) does that too.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 19, 2011 at 8:32 am

    #1275346

    Haven't seen a note on this one. Take it.

  • January 19, 2011 at 9:03 am

    #1275370

    Consider it taken then

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 30, 2012 at 10:24 am

    #1440140

    SQLRNNR (1/19/2011)

    Consider it taken then

    Heh... Talk about serindipity. I was just doing this very same thing on a production server and said to myself "this would make a great article".

    I checked as well as I could to see if you've written the article and came up with nothing. Did you ever write it? If so, can you post the URL for it?

    Thanks, Jason.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 30, 2012 at 10:26 am

    #1440141

    How about you, Steve? Has anyone done the article for this that you know of?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 2, 2012 at 5:24 pm

    #1442159

    Jeff Moden (1/30/2012)

    SQLRNNR (1/19/2011)

    Consider it taken then

    Heh... Talk about serindipity. I was just doing this very same thing on a production server and said to myself "this would make a great article".

    I checked as well as I could to see if you've written the article and came up with nothing. Did you ever write it? If so, can you post the URL for it?

    Thanks, Jason.

    Still on my to do list. I have everything ready to go - just need to write it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 10 posts - 1 through 9 (of 9 total)

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