[AccessD] One-click upsizing and downsizing of Access to SQL Serverand back?

But wait what if the backend access mdb goes down while waiting for SQL 
server to come back up.
Sorry couldn't resist.
The only secure guaranteed way is server failover, a second independent 
server with an independant UPS that has hourly backups and automatic 
transaction log shipping. Generally you will be running with triple 
mirrored disks, to do the backup you break one mirror to do the backup.. 
Oh yes the servers should be at least 200 miles apart. There are 
companies that lease hotsites, I have only done it for IBM mainframes 
though.

remember the old adage

"Good, fast, or cheap. Pick any two, but you can't have all three." - 
Red Adair Oil Well fire fighter

Steve Conklin (Developer at UltraDNT) wrote:

>Ok, I'll bite ...
>If the server is down, WHAT exactly will you "downsize"?
>
>Or ... He wants you to "in the background" export the ENTIRE SQL db into
>Access after EVERY transaction?
>
>Good luck,
>Steve
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher
>Hawkins
>Sent: Monday, January 03, 2005 7:33 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] One-click upsizing and downsizing of Access to SQL
>Serverand back?
>
>
>This is a strange request.  Bear with me.
>
>
>
>I have a client who I am taking from an Access back-end to a SQL Server
>backend.  Not having any previous experience with SQL Server, my client
>is nervous, and no amount of explaining or references will calm him. 
>He's asked me to build some sort of routine so that if the SQL Server
>goes down, he can "downsize" back to An Access back-end with a single
>button click.  He also wants to be able to re-upsize with a single
>button click.
>
>
>
>If he's willing to pay for the hours, I may as well.  It might turn out
>to be a fun project.  ;)
>
>
>
>I usually do my upsizing with the Upsizing Wizard.  I am aware of DTS
>but have used it only sparingly.
>
>
>
>Have any of you done anything like this before?
>
>
>
>-Christopher-
>
>
>
> 
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada