In this recipe, we will programmatically attach a database with a primary data file (
.mdf), log file (
.ldf), and multiple secondary data files (
Before we can attach a database, we must have the data files and optional log files attached. If you have not completed the Detaching a database recipe, perform the following steps:
QUERYWORKS\jraynoras the owner. This principal has been created with our development VM. Feel free to replace the appropriate code with a login available with your system.
TestDB. Open up SQL Server Management Studio and run the following code:
IF DB_ID('TestDB') IS NOT NULL DROP DATABASE TestDB GO CREATE DATABASE ...