Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
youngb912
Starting Member
14 Posts |
 Posted - 2010-08-24 : 22:29:10
|
| Hello Team,I took a backup of 100 databases on server A and will like to restore them to server B. Server B is on a different domain from server A. I have successfully transfered the backup to server B and using Management Studio to restore the database one at a time.Is there a way to restore multiple databases at once? If yes, please assist with the instruction or direction. Basically, I need to restore about 100 databases and seems tedious doing it one at a time. |
|
|
youngb912
Starting Member
14 Posts |
Posted - 2010-08-24 : 23:10:02
|
| Any help please! |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-25 : 06:44:41
|
| Generate a script to restore them - based on physical file names in the folder on Target server, or on the Source Server which will have Database Names and Backup filenames presumably. You'll also need to script the Logins and any Tasks / Jobs that you need to transfer.Don't bump your thread (especially after only 30 minutes) - people here who are giving up their time will think you are a jerk and ignore your posts. If its urgent then pay Microsoft or a consultant for advice. |
|
|
|
youngb912
Starting Member
14 Posts |
Posted - 2010-08-25 : 10:25:16
|
| Thanks for the help and advice. |
|
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2010-08-31 : 11:00:44
|
| I would look at this: http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30962/Ive used this method and it works like a charm. you'll first have to script out and then recreate your logins.. search for sp_help_revlogin |
|
|
|
|
|
|
How to restore multiple databases to a new server