The on-line database of listings, etc, at www.SMARTERYellowpages.com , Biz1, is read-only in normal operation.
The off-line database, Biz2, is not read-only in normal operation, and it is currently updated daily on a backup machine, including automatic backup, and updating of full-text indexes (SQL7). It's backup is used to update Biz1. Since the 2 databases are on different machines, they can and do have the same name. Updating of Biz1 is a simple restore using the most recent Biz2 backup, followed by updating the full-text index. Is there a way to have Biz1 & Biz2 on the same machine, and: To update Biz1, switch Biz2 to read-only. Switch www.SMARTERyellwpages.com to read from Biz2 instead of Biz1 Update Biz1 using the latest backup of Biz2. I haven't tried this but I wonder how to work around the difference DB names - or even if the name difference matters. best, paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
