Friday, February 17, 2012

Concurrent Backup/Restores

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
RobDon'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
>

No comments:

Post a Comment