VINCENZO69
asked on
Is there a quick way to restore multiple databases?
Hi,
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?
Thanks,
Vin
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?
Thanks,
Vin
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.