How to restore the database in VB

liyijeans

I want to implement the backup and restore function of MS-SQL database in VB. The backup is made ~~

Backup I called a stored procedure "back_cpxs" to backup, here is the code
Dim cnn As ADODB.Connection
     Set cnn = New ADODB.Connection
     cnn.Open ConnectString
    cnn.Execute "exec back_cpxs '"&lujing&"'"
    cnn.Close

When recovering the database, I also called the stored procedure recovery, but it was prompted that the current database is in use and cannot be recovered
How can I achieve database recovery?

yflovefly

-Use the following statement to first kill the process of accessing this database
declare @ss varchar (8000)

Select @ ss = isnull (@ss, '') + 'kill' + Cast (spid as varchar)
 from master..sysprocesses where dbID = db_id ('library name')
exec (@ss)

liyijeans

Kil access to the database?
I’m a rookie~~ Can you tell me more

liyijeans

Master, come and help