Autoback of SQL Database using C#.net Application

Question

Hi friends I want 2 autobackup database when user close application.

Vijay Yadav · Answer

Hi Pravin I hope this will work please try it.. backup database databasename to disk = 'c:\databasename.bak' Thanks Vijay

Pravin Ghadge · Answer

Thanks 4 ur reply Kiran But I have not understand how to optimise ur code in C#.net application. Iam totally confuse.Plz help me out

Kirtan Patel · Answer

as you execute the normal sql statements through c# code you can also execute these backup statement on Timer Event ..also for automatic back up of database

Pravin Ghadge · Answer

Thanks for ur reply But i want Autobackup through C#.net code

Kirtan Patel · Answer

you can Execute backup statements on SQL Server to Backup particular database ...on server Backing Up a Whole Database BACKUP DATABASE { database_name | @ database_name_var } TO [  ... n ] [ ] [ next-mirror-to ] [ WITH { DIFFERENTIAL | [  ... n ] } ] [;] Backing Up Specific Files or Filegroups BACKUP DATABASE { database_name | @ database_name_var } [  ... n ] TO [  ... n ] [ ] [ next-mirror-to ] [ WITH { DIFFERENTIAL | [  ... n ] } ] [;] Creating a Partial Backup BACKUP DATABASE { database_name | @ database_name_var } READ_WRITE_FILEGROUPS [  [  ... n ] ] TO [  ... n ] [ ] [ next-mirror-to ] [ WITH { DIFFERENTIAL | [  ... n ] } ] [;] Backing Up the Transaction Log (full and bulk-logged recovery models) BACKUP LOG { database_name | @ database_name_var } TO [  ... n ] [ ] [ next-mirror-to ] [ WITH { | } [  ... n ] ] [;] ::= { { logical_device_name | @ logical_device_name_var } | { DISK | TAPE } = { ' physical_device_name ' | @ physical_device_name_var } } ::= MIRROR TO [  ... n ] ::= { FILE = { logical_file_name | @ logical_file_name_var } | FILEGROUP = { logical_filegroup_name | @ logical_filegroup_name_var } } ::= FILEGROUP = { logical_filegroup_name | @ logical_filegroup_name_var } [ ...n ]::= --Backup Set Options COPY_ONLY | { COMPRESSION | NO_COMPRESSION } | DESCRIPTION = { ' text ' | @ text_variable } | NAME = { backup_set_name | @ backup_set_name_var } | PASSWORD = { password | @ password_variable } | { EXPIREDATE = { ' date ' | @ date_var } | RETAINDAYS = { days | @ days_var } } --Media Set Options { NOINIT | INIT } | { NOSKIP | SKIP } | { NOFORMAT | FORMAT } | MEDIADESCRIPTION = { ' text ' | @ text_variable } | MEDIANAME = { media_name | @ media_name_variable } | MEDIAPASSWORD = { mediapassword | @ mediapassword_variable } | BLOCKSIZE = { blocksize | @ blocksize_variable } --Data Transfer Options BUFFERCOUNT = { buffercount | @ buffercount_variable } | MAXTRANSFERSIZE = { maxtransfersize | @ maxtransfersize_variable } --Error Management Options { NO_CHECKSUM | CHECKSUM } | { STOP_ON_ERROR | CONTINUE_AFTER_ERROR } --Compatibility Options RESTART --Monitoring Options STATS [ = percentage ] --Tape Options { REWIND | NOREWIND } | { UNLOAD | NOUNLOAD } --Log-specific Options { NORECOVERY | STANDBY = undo_file_name } | NO_TRUNCATE