Microsoft SQL Server 2008 R2 Specifiche Scaricare il pdf (Pagina 77)

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

1 2 ... 72 73 74 75 76 77 78 79 80 81 82 ... 235 236

Nessun commento

Microsoft SQL Server 2008 R2 Specifiche Pagina 77