Is there a quick way to restore multiple databases?
Posted on 2008-02-11
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?