Server.DetachDatabase Method
Detaches a database from the instance of SQL Server.
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.
Overload List
| Name | Description |
|---|---|
| Server.DetachDatabase (String, Boolean) |
Detaches the specified database from the instance of SQL Server with the option to update statistics before the database is detached.
|
| Server.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.
|
See Also