Francisco Tapia
fhtapia at gmail.com
Fri Jan 7 11:20:51 CST 2005
if the data is valuable, then redundancy is key for your sql server, at the very least the data should reside on a Raid Mirror, generally Raid 10 is best for the Transaction logs and Raid 5 is generally acceptable for the data files... So Create backups of your Sql Server db files on a regular baisis, and reguluar backups of the transaction log based on how valuable the data is... these files ought to then be copied over to another server / pc for safer storage and moved to DVD / Tape. When a Sql Server goes down and the db is inaccessable, you'll need to restore these backup files to a backup sql server (sql server developer (2000) is currently $50 bucks) at which point you'll be able to extract the data (downsize) to an Access Database. Imho I think since you'll need to go through the trouble of getting a 2nd server up and running just to get at the files, it is probably most effecient to set up a fail over server... I'd check w/ MS but I think for failover servers, the cost is very low.. you only pay on the licensing on the primary server (however again you'd need to check w/ MS and their reps for accurate info). On Tue, 4 Jan 2005 11:05:24 -0800 (PST), David Mcafee <dmcafee at pacbell.net> wrote: > SQL is a lot more stable than Access. It sounds as if > he might of had some instability or corruption > problems in the past. If he truly fears the > possiblibility of SQL server going down, there are > many tools already built for the purpose that are > available, or as others have mentioned mirroring of > drives and or servers. > > If you STILL going to do it, you could run a job on > the SQL server that backs up every hour or so and copy > that back up file to a PC somewhere. Using MSDE on a > PC somewhere you could execute a stored procedure > which would run the restore of the database on this > box and change your ADPs connection to this box. > > Fugly, but it would work. > > David > > --- Christopher Hawkins <clh at christopherhawkins.com> > wrote: > > > I think his idea is that I use the most recent > > backup. > > > > This is possibly the goofiest thing I have ever > > been asked to do. But I'm going to take a stab at > > it. If nothing else it might be fun. > > > > ---------------------------------------- > > From: DWUTKA at marlow.com > > Sent: Tuesday, January 04, 2005 8:51 AM > > To: accessd at databaseadvisors.com > > Subject: RE: [AccessD] One-click upsizing and > > downsizing of Access to SQL Server and back? > > > > Just out of curiousity, how do you downsize 'back' > > to an Access database > > from a SQL Server database, if the SQL server > > database is down? I think > > that would be a little difficult, no matter how well > > you code, unless you > > are constantly writing out to an .mdb somewhere. > > > > Drew > > > > -----Original Message----- > > From: Christopher Hawkins > > [mailto:clh at christopherhawkins.com] > > Sent: Monday, January 03, 2005 6:33 PM > > To: accessd at databaseadvisors.com > > Subject: [AccessD] One-click upsizing and downsizing > > of Access to SQL > > Server and 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- > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- -Francisco http://pcthis.blogspot.com | PC news with out the jargon!