<div>
<div class="content wysiwyg-content">
Hi,<br />
My MS SQL 2005 database server is currently running 94 different databases.<br />
The db's are backed up nightly as full db backups.<br />
<br />
Here's my issue...<br />
I have a new server - is there a quick way of restoring all 94 databases and logins on this new server?<br />
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?<br />
<br />
Are there any 3rd party tools out there that will do this?<br />
<br />
Thanks,<br />
Vin<br />
<br />
<br />

</div>
</div>


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




Is there a quick way to restore multiple databases?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.