Post reply

SQL 2005 Express Backup from WinForms App

  • January 21, 2008 at 9:04 am

    #182211

    We have a Winforms .Net app using SQL 2005 Exporess database. which we are distributing to the public,

    what is the best way to backup the database? from the application ? what about doing a resore?

    Would like to hear your thoughts 🙂

    Thanks Richard Buchner, Chicago

  • January 21, 2008 at 9:15 am

    #770177

    Backups, maybe have them set a preference (folder) and run a backup to there? depending on how knowledgeable your users are, either let them pick a name, run it as database_datetime, or maybe run like the SQL Server error log, do 5, then roll over. You can always query the file for the date of the backup.

    For restores, maybe look at how Windows does it and keep it similar? Interface-wise. The restore is a simple T-SQL command.

  • January 21, 2008 at 9:15 am

    #770179

    Oh and I'd set the databases in simple mode. Not sure you want to deal with up to the minute recovery for users.

    If you do, then you need to manage log files and backups as well.

  • January 21, 2008 at 10:26 am

    #770212

    Steve Jones - Editor (1/21/2008)

    Backups, maybe have them set a preference (folder) and run a backup to there? depending on how knowledgeable your users are, either let them pick a name, run it as database_datetime, or maybe run like the SQL Server error log, do 5, then roll over. You can always query the file for the date of the backup.

    For restores, maybe look at how Windows does it and keep it similar? Interface-wise. The restore is a simple T-SQL command.

    Thanks steve, our users are not knowledgeable at all the do not even know what a database is, the database will never be very big, so I see your point on "simple" would you do the backup in an sproc?

    Thanks

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

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