Post reply

Backup

  • October 12, 2004 at 7:57 am

    #112449

    Hi All!

     Iam using MSDE as my DB for a desktop application designed to run on Win2K,XP.

    What is the best way to take DBbackup which includes only tables?

  • October 12, 2004 at 10:40 am

    #526370

    You cannot take a backup that includes only tables and I'm not sure what you are trying to do? Are you looking to make periodic backups? Is your app going to do this? The SQL-DMO libraries will allow you to perform a backup of your databases.

  • October 13, 2004 at 1:38 am

    #526469

    Hi Steve,

    What I envisage in my application, is that user should be able to take DB backup periodically

    Iam not sure whether the following approach is correct

    1.Stop DB  2. Detach DB   3. Save .mdf and .ldf files wherver user wishes with .bak extension         4.Attach DB with orginal file

    5.Start DB

    Is there any other method to do this,as I find this method unwieldy?

    Thanks in Advance

    Regards

    Girish

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply