Re: Windows forms application and database back-up

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

James,

Why not simple try it, to make a sample about this takes less time then creating the message as you did.

While as you have it ready it needs only a copy and paste.

Cor

"James Page" <JamesPage@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0C872FA2-077F-4F2B-BEE5-D25D7348DD54@xxxxxxxxxxxxxxxx
Thanks everyone for your input.

To clarify here is the full picture:

The client buys and sells used vans here in the UK and wants keep a record
of how much he spends on a vehicle and how much he sells them for. Plus he
wants to keep a historical record of all the vehicles that pass through his
business.

Designing the forms application, and the underlying database, is fairly
straightforward, but in the event of a computer failure or change of pc I
wanted a simple way for him to press a button from within the app so that the
underlying database is copied to a location of his choice (usb stick, cd etc).

Once the original application is reinstalled he should be able to click
another button that overwrites the empty database file with the backup that
he created before.
Ideally this needs to be achieved without my intervention.

The design of the application is with VS2008 and is deployed with sql
express, installer 3.1 etc.
It is to be used on a single stand alone pc.

Am I right in thinking that a basic ‘file copy’ / ‘file write’ scenario
cannot be achieved once the application has been deployed or does the
database file only get attached whilst the application is running?
If the latter is true I should be able backup & restore by writing a
standalone application that does not invoke the attachment of the *.mdf/
*.ldf files to sql express – or is my thinking wrong on this?

Looking forward to your thoughts...

Many thanks


.

Relevant Pages

  • RE: Windows forms application and database back-up
    ... The client buys and sells used vans here in the UK and wants keep a record ... underlying database is copied to a location of his choice ... The design of the application is with VS2008 and is deployed with sql ... database file only get attached whilst the application is running? ...
    (microsoft.public.dotnet.general)
  • RE: Datatable Update method not updating
    ... underlying database, and then update the current value to database. ... What does the update SQL statement looks like in your application? ... 3, start trace. ... Would you please post the trace log in the newsgroup? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Upload document
    ... SharePoint stores documents in its underlying database (e.g. MS SQL or MSDE) ...
    (microsoft.public.sharepoint.portalserver.development)
  • WSS on SQL 2005
    ... Is there going to be support (as is, service pack, patch or whatever) in WSS ... for SQL 2005, once it is released, as the underlying database? ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: indexname not supported for VFP
    ... You would hope the underlying database would choose an appropriate index when you do that - that's what most do. ... No idea whether VFP does or not - I no idea it even supported SQL. ... Is there any way to use 'set order to' in an SQL statement? ...
    (borland.public.delphi.database.ado)