Attach Database
Attach a local database to a server instance.
Privileges
Normal
Input Parameters
Name | Type | Required | Description |
---|---|---|---|
SQL Server | String | Yes | The name of the server that is hosting SQL Server. |
Database | String | Yes | The name of the database. |
Database MDF File | String | Yes | The path to the MDF file for the target database. |
Database Log File | String | Yes | The path to the database log file. |
Output Parameters
Name | Type | Description |
---|---|---|
Result | Number | Returns a success value of zero or any value other than zero to indicate failure. |
Example Input Parameters
Name | Type | Required | Example |
---|---|---|---|
SQL Server | String | Yes | Localhost |
Database | String | Yes | SQLdev |
Database MDF File | String | Yes | C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\MSDBData.MDF |
Database Log File | String | Yes | C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\MSDBLog.LDF |