Paul, Damn...I need a rethink obviously! To Paul M, the VSS Syncback copy of VFP tables would seem to be very stable if you disregard the indexes. In the event of a failover I usually instigate an index recreation regardless just to make sure. In the 18 trial failovers each month since we started I have only had one busted index so far, but as I say I always reindex as a matter of procedure
Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: 08 February 2008 18:26 To: [email protected] Subject: Re: Backing up data from a running application Dave Crozier wrote: > Bill, > 1. Primarily, all our servers are raid HP Kit with redundant power supplies > etc. we have 3 servers in total connected in a triangle with gigabit fibre > between each point. The HP intelligent hubs can route traffic automatically > down any of the triangle legs should any leg fail. Also each fibre link also > has a standby duplicate fibre leg in the same ducting. > Dave In the same ducting ? It's the only weak point I can see ... Paul Newton > 2. The main primary server real time mirrored onto a secondary server which > is on our other site. The software used is Doubletake which you may well > have heard me eulogize over in list. If the main server dies the secondary > server takes over within 15 seconds and assumes the primary IP address > automatically until the primary server is fixed. > > 3. The secondary server is snapshot every 15 minutes onto a tertiary server, > again at a different location and this snapshot is also committed to tape at > the same time with each days snapshot(s) tape removed off site daily. > > 4. The VFP Backup program also saves a VFP snapshot onto the secondary > server every hour. > > 5. The 55Gb of data is also mirrored nightly onto USB 120Gb external drive > using Syncback Software (Cycled one per day over a week) and these are taken > off site by one of the directors - all data is encrypted needless to say. > > 6. We also have UPS's on all the PC's and servers as well as a standby > generator at each of the server locations which is capable of running about > 10 client PC's and the server as all the computers are on a separate > electricity sub system to the normal office. > > At present we run at about 55Gb data storage size in total with the VFP > system using up about 1.8Gb and we actually test a real failover once every > month as well as a complete restore onto a 4th development server. > > I think we have covered all the bases, and short of nuclear holocaust > breaking out we are covered. > > Dave Crozier > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
