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
>
Friday, February 17, 2012
Concurrent Backup/Restores
Labels:
affect,
backup,
concurrent,
database,
enterprise,
instances,
manager,
microsoft,
multiple,
mysql,
oracle,
performance,
processing,
restore,
restores,
running,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment