Backup MSDE database from .bat file

Hi,

I have seen hundreds of suggestions on how to backup a MSDE database on
the net, most of them have different approaches.

Does it exist an 'approved' way of doing this?

I need to run a .bat file which backs up my MSDE database (i.e. stops
the server, performs copying and the starts the MSDE engine again).

Thanks for hints on where to find the 'bulletproof' way of doing this.
I also need to know how to restore such a backup ;-)

Thanks if there is a kind soul somewhere

best regards

Tor

.

Relevant Pages

  • List database names..?
    ... success. ... MSDE database to know the correct name to insert in the statement above? ... Also which parameter do I set for the backup to ensure a full backup each ... Rod ...
    (microsoft.public.sqlserver.msde)
  • MSDE Command Line Backup
    ... I am trying to backup an MSDE database through osql, but it does not seem to work. ... I connect as sa and issue the following command, I do not get an error, or any other feedback, and the file is not created. ...
    (microsoft.public.sqlserver.msde)
  • Converting a SQL Database to MSDE
    ... everything else is done on the backend. ... MSDE database that I can distribute to my userbase so they can play. ... said all I need to do is a backup and restore -- but I'm not sure how it ...
    (microsoft.public.sqlserver.server)
  • MSDE 2000 backups and restores
    ... I have chosen simple recovery mode for MSDE Database and do a full backup ... The problem is I don't really understand how the differential backup should ... Do you use a different file name for the Full and Differential backups? ...
    (microsoft.public.sqlserver.msde)
  • Moving MSDE database
    ... You will have to backup and restore the DB's as described ... in the Administrator's Guide. ... >How can I move th MSDE database to a different drive? ...
    (microsoft.public.sharepoint.windowsservices)