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