Specifications

Deleting a Data-Tier Application CHAPTER 3 57
■
Delete Database The DAC metadata and the associated database are dropped.
The data and log les are deleted. Logins are not removed.
To delete the DAC, follow these steps:
1. In Object Explorer, connect to a SQL Server instance containing the data-tier applica-
tion you plan to delete.
2. Expand the SQL Server instance, and then expand the Management folder.
3. Expand the Data-Tier Applications node, right-click the data-tier application you want
to delete, and then select Delete Data-Tier Application.
4. Review the information in the Introduction page, and then click Next to begin the de-
letion process. Select the Do Not Show This Page Again check box if you do not want
the Introduction page displayed in the future when using the wizard.
5. On the Choose Method page, specify the method you want to use to delete the
data-tier application, as illustrated in Figure 3-9. The options are Delete Registration,
Detach Database, and Delete Database. Click Next to continue.
FIGURE 3-9 Choosing the method with which to delete the DAC with the Delete Data-Tier Ap-
plication Wizard