Server.AttachDatabase Method
Attaches an existing database that is made up of one or more files to 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.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.
|
| Server.AttachDatabase (String, StringCollection, AttachOptions) | |
| Server.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.
|
| Server.AttachDatabase (String, StringCollection, String, AttachOptions) |
See Also