MS SQL Server - Concurrent Backup/Restores

Author

Concurrent Backup/Restores

Rob Diamant

2006-03-09, 11:23 am

Can I have multiple instances of Enterprise Manager running while each one
is processing a backup or restore. How will this affect performance. I am
trying to restore several large databases and do not want to have to do this
sequentially if if possible. Does it make any difference if I am running EM
on different PCs?

TIA

Rob

Andrew J. Kelly

2006-03-09, 8:23 pm

Don't use EM, use QA instead along with the BACKUP and RESTORE commands. You
will be limited only by processor and disk bandwidth.

--
Andrew J. Kelly SQL MVP

"Rob Diamant" <rob@usi.com> wrote in message
news:Ol%234qV5QGHA.196@TK2MSFTNGP10.phx.gbl...
> Can I have multiple instances of Enterprise Manager running while each one
> is processing a backup or restore. How will this affect performance. I am
> trying to restore several large databases and do not want to have to do
> this sequentially if if possible. Does it make any difference if I am
> running EM on different PCs?
>
> TIA
>
> Rob
>

Sponsored Links