Error with RESTORE DATABASE in vb.net code

cn.open() 'current connection
Dim comSQL As New SqlClient.SqlCommand
comSQL.Connection = cn

comSQL.CommandText = "RESTORE DATABASE  FROM DISK = '' WITH REPLACE, NORECOVERY, PASSWORD = ''"

comSQL.ExecuteNonQuery()
cn.close()

In both cases, the operation fails and the error message 'excusive access could not be obtained because the database is in use' is generated. The current database connection is only used as a placeholder for user databases that are brought into the application for data editing and reporting, so the current database info is disposable. How can I perform this restore operation in code?

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL/Transact SQL (T-SQL) Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server SQL language crash course (just enough to be dangerous) Working with IntelliSense in SQL Server 2008 Management Studio SQL Server Mailbag: Stored procedures, triggers and SSRS reports Working with sparse columns in SQL Server 2008 Determining the source of full transaction logs in SQL Server New GROUP BY option provides better data control in SQL Server 2008 Using the OPENROWSET function in SQL Server Loading data files with SQL Server's BULK INSERT statement Importing and exporting bulk data with SQL Server's bcp utility SQL/Transact SQL (T-SQL) Research Michael Hotek Applying LDF file to MDF without turning it to .BAK first? Procedure for finding last modified info? Migrating poorly designed database to new, normalized one Displaying decimal places in SQL Server 2000 Creating a DTS package Extracting data without strings converted to strange characters Money data type conversion issue using DTS Any way to alias a call to functions? Repairing corrupt MDF files In-place versus side-by-side upgrade

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary ACID  (SearchSQLServer.com) Collaboration Data Objects  (SearchSQLServer.com) commit  (SearchSQLServer.com) container  (SearchSQLServer.com) DAO  (SearchSQLServer.com) fetch  (SearchSQLServer.com) OLE DB  (SearchSQLServer.com) query  (SearchSQLServer.com) SQL  (SearchSQLServer.com) T-SQL  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

Change your database context to master. You will also have to kill off any SPID that is connected to the database you are trying to restore. Refer to the kill command in BOL.

For More Information

• Dozens more answers to tough SQL Server questions from Michael Hotek are available here.
• The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
• Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
• Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
• Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, object-oriented and data warehousing gurus are waiting to answer your toughest questions.