Server.DetachDatabase Method
Include Protected Members
Include Inherited Members
Detaches a database from the instance of SQL Server.
This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.
Overload List
| Name | Description | |
|---|---|---|
.gif "Public method") |
DetachDatabase(String, Boolean) | Detaches the specified database from the instance of SQL Server with the option to update statistics before the database is detached. |
|
DetachDatabase(String, Boolean, Boolean) | Detaches the specified database from the instance of SQL Server with the option to update statistics before the database is detached. |
Top
Remarks
The data and transaction log files of a database can be detached and then reattached to the same or another instance of SQL Server. Detaching and attaching a database is useful if you want to change the database to a different instance of SQL Server on the same computer, or if you want to move the database.