December 17, 2009 at 7:16 am
hi
we have planned to migrate sql server 2005.i have around 50 backup files. i want to restore databases using those 50 backup files. restoring individual database will take lot of time. is there any best way to do now?
Thanks
Rock...
December 17, 2009 at 7:21 am
You should create a script to cycle through a list of the databases you need to restore. Would be quicker / easier than doing them all manually.
December 17, 2009 at 8:50 am
Ditto to the T-SQL script creation. Easiest and quickest way.
You could also try to use SSIS's Copy Database tasks. Though it tends to be messy and not create things in the correct order. Dependencies cause issues.
December 18, 2009 at 7:39 am
When I migrated 35 DBs to our new SQL Server I started up Profiler then went through Mgt Studio and did the restore with all of the file path changes and saved off all of the restore dbs to one script. Then for the live prod migration I simply executed that. It runs SO much quicker that way and no fat finger mistakes.
December 18, 2009 at 7:54 am
rockingadmin (12/17/2009)
hiwe have planned to migrate sql server 2005.i have around 50 backup files. i want to restore databases using those 50 backup files. restoring individual database will take lot of time. is there any best way to do now?
Thanks
Rock...
Does the Server, where databases are to be migrated, have same drives as originating server? If so, just replicate folders for placing respective datafiles and run restore command that should work, provided if there is no disk space issues.
If that is not the case I would agree with rest of them, you have to script it and then do a restore.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply