Server.AttachDatabase Method
Include Protected Members
Include Inherited Members
Attaches an existing database that is made up of one or more files to the instance of SQL Server.
Overload List
| Name | Description | |
|---|---|---|
.gif "Public method") |
AttachDatabase(String, StringCollection) | Attaches an existing database that is made up of one or more files to the instance of SQL Server with the specified name and using the specified data files. |
|
AttachDatabase(String, StringCollection, AttachOptions) | |
|
AttachDatabase(String, StringCollection, String) | Attaches an existing database that is made up of one or more files to the instance of SQL Server with the specified name and using the specified data files. |
|
AttachDatabase(String, StringCollection, String, AttachOptions) |
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.