Post reply

Restore 500 databases from a share location

  • November 23, 2015 at 6:31 am

    #322426

    Hi All,

    I got a requirement to restore 500 database on SQL 2012 instance form a production backup share location. task ment for building a DR server for the production. As part of this i have installed SQL with simlar configuration as production. I would to restore these many databases from a prodction share parth.

    Please let me know if you have a scripts to automate or simi automate my requirments .

    Thanks

  • November 23, 2015 at 6:43 am

    #1841689

    it depends on the details, but regardless, you have to generate the list of commands from some place; the msdb backup history from production, or the folder full of files, or some other method.

    it gets more complex depending on what you need to do...last full backup, or do you need to applu full/diff/log backups on a per database bassis...that's going to depend on naming conventions, most likely.

    this link was one of the first i googled that had a decent example; this is assumine one full backup per database exist sint he folder:

    http://stackoverflow.com/questions/22207519/need-help-to-restore-multiple-databases-bak-files-from-one-folder

    the more info you provide, the more we can help you.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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