I also have issues bringing the core system down for 'n' hours while I:
- Kill data acquisition
Backup the Publisher DB (160GB+ data file)
Backup the Subscriber DB (35GB+ data file)
(and that's if I don't do the recommended parallel database method.)
Based on current times, installing and commissioning on the Production server, SS2005 Enterprise, will take at least 6 hours, as rebuilding replication takes about 4 hours!
This seems like an entirely unreasonable length of time to take the core business system down - assuming all goes well end-to-end.
Is there no quicker way the transition can be effected? Are efforts underway down-under to perhaps make the downtime much shorter?
Those of us with large-enough DBs and Replication implications are presented with a hard pill to swallow, let alone convincing Management that the downtime window is "this big" and there's no other path to storage compression but through that hole...