Is there a quick way to restore multiple databases?

My MS SQL 2005 database server is currently running 94 different databases.
The db's are backed up nightly as full db backups.

Here's my issue...
I have a new server - is there a quick way of restoring all 94 databases and logins on this new server?
I cannot take my existing server offline (its not an option) so is it a ase of manually restoring each db and then fixing the Orphaned users as I find them?

Are there any 3rd party tools out there that will do this?


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Red Gates SQL BAckup may be able to help you.  Also, there are probably some tools out there that will make a copy of your server and restore it at another place.

you rbest bet would be to configure the new server as a mirror and allow the first server to synchronise with teh secodn, whilst it might take a littl ebit of time to set up will ensure you get teh most accurate copy with the least downtime. shoudl only require one reboot,289483,sid87_gci1199004,00.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CA Wansync has a pretty nifty tool for this kind of thing. Quite pricey for a migtration - but they used to have an evaluation option. I've not used it for SQL Server but it's excellent with Exchange - as far as I'm aware it does the same thing with SQL Server. Otherwise SQL replication to a mirror server is a more difficult but cheap way to go.

Are you sure that 94 databases on one server is the best option? Sounds like an awful lot of eggs in one basket to me! I've had issues where one application decides to run a query which creates a deadlock but then locks the whole server. If you can, segregate your DB's or apps onto different instances and/or servers.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.