• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 50
  • Last Modified:

Howto Bulk restore 500 db MS12

Need to bulk move and restore 500 database to a new MS SQL 2012 sql instance. They are data.bak files.  It seems because of a having a new database server have to restore each one individually. How can restore them all in a bulk on a windows 2012 MS SQL server.
1 Solution
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
If I understand the question, you already have the databases backed up to .bak files.  Are they all in one file, or in 500 different individual backup files?
I'd be awfully tempted to write a script to generate a TSQL script with the individual restore commands to plug through the restores.  I'd probably use someone else's script as a starting point.  Do you still have access to the old server's master database, so you can at least pull the databases from sys.databases or the equivalent?
Vitor MontalvãoMSSQL Senior EngineerCommented:
So, you'll have a single instance with 500 databases!?
Consolidation is good but don't exaggerate.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now