Backup and recovery of Remote SQL Server databases under ASP. NET

 

The help document address of SQL Server. Just enter it in IE.
MK: @ msitstore: C: \ Program % 20files \ microsoft % 20sql % 20server \ 80 \ tools \ books \ tsqlref. chm:/ts_ba-bz_35ww.htm

Backup database to disk path backup
Restore database from disk path

Using system; using system. collections; using system. security. cryptography; using system. data; using system. data. sqlclient; using system. web; using system. web. sessionstate; using system. web. ui; using system. web. UI. webcontrols; using system. web. UI. htmlcontrols; using system. diagnostics; using system. text; using system. componentmodel; using system. configuration; using system. data. oledb; namespace dbservice {// <Summary> // dboper class, mainly implements backup and recovery of Microsoft SQL Server databases /// </Summary> Public sealed class dboper {/// <summary> /// dboper class constructor /// </Summary> // Private dboper () // {//} // <summary> // Database Backup // </Summary> // public static string backfilename = system. web. httpcontext. current. request. physicalapplicationpath + "backup \ mydbback. bak "; public static void dbbackup (string dbnanme, string userid, string PWD) {try {sqldmo. backup obackup = new sqldmo. backupclass (); sqldmo. sqlserver osqlserver = new sqldmo. sqlserverclass (); osqlserver. loginsecure = false; osqlserver. connect ("localhost", userid, PWD); obackup. action = sqldmo. sqldmo_backup_type.sqldmobackup_database; obackup. database = dbnanme; obackup. files = backfilename; obackup. backupsetname = dbnanme; obackup. backupsetdescription = "database backup"; obacku P. initialize = true; obackup. sqlbackup (osqlserver) ;}catch {Throw ;}} /// <summary> /// restore the database function /// </Summary> /// <Param name = "strdbname"> database name </param> /// <param name = "strfilename"> full path name of the database backup file </param> // <returns> </returns> Public bool restoredb (string strdbname, string strfilename, string userid, string PWD) {// pbar = pgbmain; sqldmo. sqlserver SVR = new sqldmo. sqlserverclass (); try {// server Name, database username, database username and password SVR. connect ("localhost", userid, PWD); sqldmo. queryresults QR = SVR. enumprocesses (-1); int icolpidnum =-1; int icoldbname =-1; for (INT I = 1; I <= QR. columns; I ++) {string strname = QR. get_columnname (I); If (strname. toupper (). trim () = "spid") {icolpidnum = I;} else if (strname. toupper (). trim () = "dbname") {icoldbname = I;} If (icolpidnum! =-1 & icoldbname! =-1) break;} // kill the process using the strdbname database for (INT I = 1; I <= QR. rows; I ++) {int LPID = QR. getcolumnlong (I, icolpidnum); string strdbname = QR. getcolumnstring (I, icoldbname); If (strdbname. toupper () = strdbname. toupper () {SVR. killprocess (LPID) ;}} sqldmo. restore res = new sqldmo. restoreclass (); Res. action = 0; Res. files = strfilename; Res. database = strdbname; Res. replacedatabase = true; Res. sqlrestore (SVR); Return true;} catch {return false;} finally {SVR. disconnect ();}}}}