SQL Server Management Pack Tasks
The SQL Server Management Pack includes a number of tasks to help administer, test, and troubleshoot SQL servers, including the following:
• Check Catalog (DBCC)—Launches a script to check the online DB’s catalog consistency
• Check Database (DBCC)—Launches a script to check the allocation, logical integrity, and structure of the objects in the target DB
• Check Disk (DBCC)—Launches a script to check the allocation structure consistency of the disk space of the target DB
• Set Database Offline—Launches a script to set the database to an OFFLINE state, using ALTER DATABASE (target DB) SET OFFLINE
• Set Database Online—Launches a script to set the database to an ONLINE state, using ALTER DATABASE (target DB) SET ...
Get Microsoft® System Center 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.