TechNet
Export (0) Print
Expand All

Server.DetachDatabase Method

 

Detaches a database from the instance of SQL Server. 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubmethodDetachDatabase(String, Boolean)

Detaches the specified database from the instance of SQL Server with the option to update statistics before the database is detached.

System_CAPS_pubmethodDetachDatabase(String, Boolean, Boolean)

Detaches the specified database from the instance of SQL Server with the option to update statistics before the database is detached.

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.

Return to top
Show:
© 2016 Microsoft