Restore and restore an sqlserver database using asp.net

Create proc killspid (@ dbname varchar (20 ))
As
Begin
Declare @ SQL nvarchar (500)
Declare @ spid int
Set @ SQL = declare getspid cursor
Select spid from sysprocesses where dbid = db_id (+ @ dbname +)
Exec (@ SQL)
Open getspid
Fetch next from getspid into @ spid
While @ fetch_status <>-1
Begin
Exec (kill + @ spid)
Fetch next from getspid into @ spid
End
Close getspid
Deallocate getspid
End
GO

Run the stored procedure before restoration. You need to pass dbname, which is the name of your database. Below is the original code of the class: (the database connection string in web. config is constr)
 

Using System;

Using System. Configuration;

Using System. Data. SqlClient;

Using System. Data;

Namespace web. base_class

{

/// <Summary>

/// DbOper class, mainly using SQLDMO to back up and restore the Microsoft SQL Server database

/// </Summary>

Public class DbOper

{

Private string server;

Private string uid;

Private string pwd;

Private string database;

Private string conn;

/// <Summary>

/// DbOper Constructor

/// </Summary>

Public DbOper ()

{

Conn = System. Configuration. ConfigurationSettings. receivettings ["constr"]. ToString ();

Server = cut (conn, "server = ",";");

Uid = cut (conn, "uid = ",";");

Pwd = cut (conn, "pwd = ",";");

Database = cut (conn, "database = ",";");

}

Public string cut (string str, string bg, string ed)

{

String sub;

Sub = str. Substring (str. IndexOf (bg) + bg. Length );

Sub = sub. Substring (0, sub. IndexOf (";"));

Return sub;

}

 

/// <Summary>

/// Database Backup

/// </Summary>

Public bool DbBackup (string url)

{

SQLDMO. Backup oBackup = new SQLDMO. BackupClass ();

SQLDMO. SQLServer oSQLServer = new SQLDMO. SQLServerClass ();

Try

{

OSQLServer. LoginSecure = false;

OSQLServer. Connect (server, uid, pwd );

OBackup. Action = SQLDMO. SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;

OBackup. Database = database;

OBackup. Files = url; // "d: Northwind. bak ";

OBackup. BackupSetName = database;

OBackup. BackupSetDescription = "database backup ";

OBackup. Initialize = true;

OBackup. SQLBackup (oSQLServer );

Return true;

}

Catch

{

Return false;

Throw;

}

Finally

{

OSQLServer. DisConnect ();

}

}

 

/// <Summary>

/// Restore the database

/// </Summary>

Public string DbRestore (string url)

{

If (exepro ()! = True) // execute the Stored Procedure

{

Return "operation failed ";

}

Else

{