Lesson 6: Deleting a Data-tier Application
In this lesson, you will learn to delete the data-tier application (DAC) you upgraded in Lesson 5.
Procedures
Delete a DAC.
In the SQL Server Management Studio Object Explorer pane, navigate to the node for the test instance where you deployed the DAC, then open the Management node under that instance and select the Data-tier Applications node.
Right click the node for the SampleDAC, then select Delete Data-tier Application.
Review the information on the Introduction page, and then select Next.
On the Choose Method page, select Delete database. This will delete the DAC metadata and drop the database. The data and log files will be deleted.
Click Next to proceed.
On the Summary page, review the settings that will be used to delete the DAC, and then click Next.
The wizard deletes the DAC metadata from the msdb database and drops the SampleDAC database. Review the Delete DAC page to ensure all of the deployment actions were successful. Select Finish to complete the wizard.
Right-click on the node for the test instance and select Refresh. The SampleDAC database should no longer appear under the Databases node, and SampleDAC should no longer appear under the Data-tier Applications node.
Next Steps
This concludes the tutorial. Tutorials are brief overviews and do not describe all available options.