Is there a quick way to restore multiple databases?

Posted on 2008-02-11
Medium Priority
Last Modified: 2009-07-29
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?


Question by:VINCENZO69
LVL 60

Assisted Solution

chapmandew earned 375 total points
ID: 20867074
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.
LVL 25

Accepted Solution

slam69 earned 750 total points
ID: 20867124

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


Assisted Solution

Spot_The_Cat earned 375 total points
ID: 20867282
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.


Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question