Backing up MSDE using Vb.Net

[Guest]

Hi

I have a VB.net windows application that uses an MSDE database

I need to give the user the option to backup this data (and later restore it). Ideally I want to back the data up to an empty Access 2000 database that contains the table structure

I know that I can do this by stepping through each record of each table in MSDE, inserting them into the correct Access table, but i recon this will take a long time and is not very efficient

Is there a way that i can use datasets to extract full tables of data at a time from MSDE and write them to Access
Or, is there a better way

I would be grateful of any suggestion

Thanks in advanc

 

[William Ryan eMVP]

In Books online, check out the BACKUP DATABASE and BACKUP LOG commands. In
order to restore, you'll use the inverse functions, RESTORE Database.
there's good amount to backup and recovery strategy in SQL Server so you may
want to read up on the whole subject (particularly if you need Point in Time
Restores ).

As far as backing up to Access. I'd reallly recommend against this. If you
need it in Access for some other reason,, than DTS could do it very quickly,
or you could write a Macro within Access to do this. If redundancy is your
main concern though, why not backup your DB and then restore to another
instance of MSDE on the same network. It's free after all and you can
automate backup and restore much easier and cleaner and run it as a job
within SQL Server. Moreoever, if you backup your db to access, unless it's
on another machine it won't do you any good if the drive controller goes
down and if you have another machine to back it up to, why not just use MSDE
and keep things simple.

HTH,

Bill

Hi,

I have a VB.net windows application that uses an MSDE database.

I need to give the user the option to backup this data (and later restore

it). Ideally I want to back the data up to an empty Access 2000 database
that contains the table structure.

I know that I can do this by stepping through each record of each table in

MSDE, inserting them into the correct Access table, but i recon this will
take a long time and is not very efficient.

Is there a way that i can use datasets to extract full tables of data at a

time from MSDE and write them to Access?