R
Rob Fitzpatrick
Guest
Regardless of the architectural design challenges you face, without after imaging you face another significant problem in terms of data loss in the event of media failure, DB corruption, a rogue transaction, etc. Are you doing daily backups? Are they tested and known to be good? If you need to restore one can you afford a day's worth of data loss and the downtime required to recover from a backup? I don't see this as an "either-or" situation. First make sure your data is safe. Recheck your backup strategy and enable after imaging. Make sure you have a plan for what you're going to do with your AI extents (copy off prod box, roll forward, archive, culling old files, etc.) and test it. Then look at possibly restructuring your application. As Paul said, if your object names are unique it should be a straightforward change to combine the DBs.
Continue reading...
Continue reading...