Results 1 to 2 of 2

Thread: How to back up and resotre in windows applicaiton using C#?

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    208

    How to back up and resotre in windows applicaiton using C#?

    I am developing windows application using C# and MS sql server.
    Now i have completed the project except how to backup and restore.
    now i want to have a backup and restore buttons.
    when i click.. backup button i will have an option where to put the backup
    or a mechanism to take schedule backup then each back up is different, not replacing the previous backup.

    Restore: when i click restore i will have an option from where can i restore.

    please please i really need how to take backup and restore from windows interface.
    thank you for your all helps.

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,222

    Re: How to back up and resotre in windows applicaiton using C#?

    Are you saying, without actually saying, that you want to backup and restore the SQL Server database? If so then it's a simple matter of executing an appropriate SQL statement against the server using a SqlCommand, just as you would for any SQL statement. The SQL Server documentation can provide you with the appropriate syntax for a BACKUP DATABASE statement and a RESTORE DATABASE statement.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width