Diagnostics Guide
Page 9
Chapter 2: What's New and What's Changed Unicenter DSM r11 is a collection of all three products resides at a deep technical level, sharing common technology, terminology, architecture and data. The following tables provide an overview of the architectural changes introduced in r11 and indicate, in the architectural hierarchy (e.g., Manager, Scalability Server, Agent, etc). Beginning with...
Chapter 2: What's New and What's Changed Unicenter DSM r11 is a collection of all three products resides at a deep technical level, sharing common technology, terminology, architecture and data. The following tables provide an overview of the architectural changes introduced in r11 and indicate, in the architectural hierarchy (e.g., Manager, Scalability Server, Agent, etc). Beginning with...
Diagnostics Guide
Page 14
... of which is maintained using a link table. Common Application Framework and Startup Multiple instance install (uses instance names) Enhanced package version numbering (a.b.c.d) Support for multi-CD installs Web Services Web Services provide high level public interfaces into Unicenter DSM which: Enables Unicenter DSM integration into customer business processes ...
... of which is maintained using a link table. Common Application Framework and Startup Multiple instance install (uses instance names) Enhanced package version numbering (a.b.c.d) Support for multi-CD installs Web Services Web Services provide high level public interfaces into Unicenter DSM which: Enables Unicenter DSM integration into customer business processes ...
Diagnostics Guide
Page 21
... typically come from previous implementation versions Run generic SQL Run external exe Multiple Engine instances can be configured to communicate with a single Enterprise Manager. It contains both common tables and product-specific tables that can run on a machine other than the Unicenter DSM Manager. This allows you to and communicates with some...
... typically come from previous implementation versions Run generic SQL Run external exe Multiple Engine instances can be configured to communicate with a single Enterprise Manager. It contains both common tables and product-specific tables that can run on a machine other than the Unicenter DSM Manager. This allows you to and communicates with some...
Diagnostics Guide
Page 22
...the analytical data used for the sake of illustration, let us consider what happens when a computer that CAF starts up . There are a few exceptions to a system. Common Application ... objects used by CAF, essentially the first thing that happens is that is running a full Unicenter DSM Domain Manager with all products (UAM, URC, USD) and components installed (including Scalability ...Server, Agent and Web components) boots up and then starts all configured plug-ins. These include tables, columns, views, and procedures. The DSM MDB resides at the Domain Manager and the Enterprise ...
...the analytical data used for the sake of illustration, let us consider what happens when a computer that CAF starts up . There are a few exceptions to a system. Common Application ... objects used by CAF, essentially the first thing that happens is that is running a full Unicenter DSM Domain Manager with all products (UAM, URC, USD) and components installed (including Scalability ...Server, Agent and Web components) boots up and then starts all configured plug-ins. These include tables, columns, views, and procedures. The DSM MDB resides at the Domain Manager and the Enterprise ...
Diagnostics Guide
Page 61
... will see the Office 2000 components and, if you drill down into "products" and "releases." Releases are children of the is_active field in the ca_software_signature table was introduced in r11.1a and, as a result, under that product is filtered in this hierarchy and products can have been filtered from view, check...
... will see the Office 2000 components and, if you drill down into "products" and "releases." Releases are children of the is_active field in the ca_software_signature table was introduced in r11.1a and, as a result, under that product is filtered in this hierarchy and products can have been filtered from view, check...
Diagnostics Guide
Page 66
...that is created in a special (dedicated) event table. 4. Understanding Managed and Unmanaged Objects Installing DSM r11.2 with Pre-Existing Common Services Consult the DSM r11.2 Implementation Guide for detailed information on this point the computer is still considered "unmanaged" from a DSM perspective..., the DSM Agent has been installed on installing DSM r11.2 with Unicenter Netework and Systems Management (NSM), it has been discovered, the computer is now considered "managed." 9-2 Unicenter IT Resource Management Diagnostics Guide The CCS Continuous Discovery Service detects the ...
...that is created in a special (dedicated) event table. 4. Understanding Managed and Unmanaged Objects Installing DSM r11.2 with Pre-Existing Common Services Consult the DSM r11.2 Implementation Guide for detailed information on this point the computer is still considered "unmanaged" from a DSM perspective..., the DSM Agent has been installed on installing DSM r11.2 with Unicenter Netework and Systems Management (NSM), it has been discovered, the computer is now considered "managed." 9-2 Unicenter IT Resource Management Diagnostics Guide The CCS Continuous Discovery Service detects the ...
Diagnostics Guide
Page 70
...The r11 commands listed in the following table provide "similar" functionality to their actions. Unicenter Software Delivery r4 SDCONF CHKMIB_L/E SDVER SDCMD SDACMD SDPGM TNGDTS Stagechk SDSWEEP CreateBTImages CreateOSImage RegisterBTImages RegistserOSImage SDJEXEC Sdsetcnf Cazip\cazipxp Unicenter DSM r11 Dsmproperties show Currently no ... all/Stop all (also KILL to ensure that you understand their syntax as well as the full scope of their Unicenter Software Delivery r4 counterparts, but rarely identical functionality. Before executing any of these commands, you should always check the ...
...The r11 commands listed in the following table provide "similar" functionality to their actions. Unicenter Software Delivery r4 SDCONF CHKMIB_L/E SDVER SDCMD SDACMD SDPGM TNGDTS Stagechk SDSWEEP CreateBTImages CreateOSImage RegisterBTImages RegistserOSImage SDJEXEC Sdsetcnf Cazip\cazipxp Unicenter DSM r11 Dsmproperties show Currently no ... all/Stop all (also KILL to ensure that you understand their syntax as well as the full scope of their Unicenter Software Delivery r4 counterparts, but rarely identical functionality. Before executing any of these commands, you should always check the ...
Microsoft SQL Guide
Page 29
... statement. Chapter 3: Backing Up Microsoft SQL Server Databases 29 To back up a database creates a copy of files or FileGroups on another device (typically a media drive). Any data changes made since a previous backup, or a collection of its tables, data, system objects, and user... Up a Database (see Transaction Log Backups in CA ARCserve Backup, the Agent for Microsoft SQL Server, and Microsoft SQL Server 7.0, Microsoft SQL Server 2000, Microsoft SQL Server 2005 and Microsoft SQL Server 2008. The backup captures the state of the database. Backing up and truncate Transaction ...
... statement. Chapter 3: Backing Up Microsoft SQL Server Databases 29 To back up a database creates a copy of files or FileGroups on another device (typically a media drive). Any data changes made since a previous backup, or a collection of its tables, data, system objects, and user... Up a Database (see Transaction Log Backups in CA ARCserve Backup, the Agent for Microsoft SQL Server, and Microsoft SQL Server 7.0, Microsoft SQL Server 2000, Microsoft SQL Server 2005 and Microsoft SQL Server 2008. The backup captures the state of the database. Backing up and truncate Transaction ...
Microsoft SQL Guide
Page 37
... not check indexes On the Agent Backup Options dialog, Override Global Options is ignored for Microsoft SQL Server 2000 or later. If the DBCC fails, perform the backup. Note: The system table indexes are specified: ■ Before backup ■ Continue with Override Global Options on the...DBCC options specified. ■ With Override Global Options not specified, all of the DBCC options specified for user-defined tables. Chapter 3: Backing Up Microsoft SQL Server Databases 37 It still checks the integrity of the physical structure of the page and record headers, and the consistency...
... not check indexes On the Agent Backup Options dialog, Override Global Options is ignored for Microsoft SQL Server 2000 or later. If the DBCC fails, perform the backup. Note: The system table indexes are specified: ■ Before backup ■ Continue with Override Global Options on the...DBCC options specified. ■ With Override Global Options not specified, all of the DBCC options specified for user-defined tables. Chapter 3: Backing Up Microsoft SQL Server Databases 37 It still checks the integrity of the physical structure of the page and record headers, and the consistency...
Microsoft SQL Guide
Page 49
...For more information about restoring to a different location, see Restore to isolate the damaged parts of the database. Chapter 4: Restoring Microsoft SQL Server Databases 49 Note: A Files and FileGroups restore must apply the Transaction log to the unrestored FileGroups being offline. In an Offline...any other FileGroups you must be applicable. In an Online Torn Page Repair, the database remains online the entire time, and undamaged tables are similar to a Files and FileGroups restore. When restoring files or FileGroups, you specify as damaged. Otherwise, the data and ...
...For more information about restoring to a different location, see Restore to isolate the damaged parts of the database. Chapter 4: Restoring Microsoft SQL Server Databases 49 Note: A Files and FileGroups restore must apply the Transaction log to the unrestored FileGroups being offline. In an Offline...any other FileGroups you must be applicable. In an Online Torn Page Repair, the database remains online the entire time, and undamaged tables are similar to a Files and FileGroups restore. When restoring files or FileGroups, you specify as damaged. Otherwise, the data and ...
Microsoft SQL Guide
Page 52
... state if another differential backup or Transaction log after the restore of the database on a different server which contains the information SQL Server needs to make this transition. It contains a copy of the database. If a standby database is generally used when ...restoring a database from multiple sessions without checking indexes for Microsoft SQL Server Guide Note: The system table indexes are not eligible for backup, the standby database will fail. Database Consistency Check (DBCC) Options A database consistency...
... state if another differential backup or Transaction log after the restore of the database on a different server which contains the information SQL Server needs to make this transition. It contains a copy of the database. If a standby database is generally used when ...restoring a database from multiple sessions without checking indexes for Microsoft SQL Server Guide Note: The system table indexes are not eligible for backup, the standby database will fail. Database Consistency Check (DBCC) Options A database consistency...
Microsoft SQL Guide
Page 68
...the current list of time. Perform a Transaction Log backup with the Backup only the log tail and leave the database in the [suspect_pages] table of step #4. 3. Open Agent Option. On the Source tab, use the Restore By Tree view to perform a restore in which only those... data pages which is using Microsoft SQL Server 2005 1. d. Under Recovery Completion State, select Leave database operational. This will fail). 4. i. b. Disconnect all clients using the database. (Otherwise...
...the current list of time. Perform a Transaction Log backup with the Backup only the log tail and leave the database in the [suspect_pages] table of step #4. 3. Open Agent Option. On the Source tab, use the Restore By Tree view to perform a restore in which only those... data pages which is using Microsoft SQL Server 2005 1. d. Under Recovery Completion State, select Leave database operational. This will fail). 4. i. b. Disconnect all clients using the database. (Otherwise...
Microsoft SQL Guide
Page 70
... CheckDB) on the database to perform a Restore in the [suspect_pages] table of the database as part of step 4. 3. Confirm that this procedure. Online. k. In addition to torn page detection and isolation, SQL 2005 also introduces the ability to locate any other damaged or corrupted pages... is slightly damaged back into service quickly. On the Destination tab, select Restore to bring a database which a DBCC is using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions 1. Under Subset, select Torn Page Repair - Click OK. Start the...
... CheckDB) on the database to perform a Restore in the [suspect_pages] table of the database as part of step 4. 3. Confirm that this procedure. Online. k. In addition to torn page detection and isolation, SQL 2005 also introduces the ability to locate any other damaged or corrupted pages... is slightly damaged back into service quickly. On the Destination tab, select Restore to bring a database which a DBCC is using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions 1. Under Subset, select Torn Page Repair - Click OK. Start the...
Microsoft SQL Guide
Page 71
Change to query the table that contained the damaged page. 5. Attempt to Simple Recovery Model, if you changed the Recovery Model in step 1. 8. Resume use of this final Transaction Log backup without Automatic Selection, and with the default options. 6. Chapter 4: Restoring Microsoft SQL Server Databases 71 Perform a Transaction Log backup with the Recovery Completion State set to Leave Database operational. 7. Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions 4. Perform a restore of the database.
Change to query the table that contained the damaged page. 5. Attempt to Simple Recovery Model, if you changed the Recovery Model in step 1. 8. Resume use of this final Transaction Log backup without Automatic Selection, and with the default options. 6. Chapter 4: Restoring Microsoft SQL Server Databases 71 Perform a Transaction Log backup with the Recovery Completion State set to Leave Database operational. 7. Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions 4. Perform a restore of the database.
Microsoft SQL Guide
Page 96
...an error or warning and marks the job as the setting name that governs how databases ineligible for creating and setting DWORDS follows the table. The procedure for backup are recognized and handled. For each selection type, as well as Failed or Incomplete, depending on the following... the default behavior is determined by adding controller values to the Agent settings in the Windows Registry on the computer on which the CA ARCserve Backup Agent for Microsoft SQL Server is Selected Standby (read-only, waiting to receive additional restores) Message Type: Error Message Type: Warning...
...an error or warning and marks the job as the setting name that governs how databases ineligible for creating and setting DWORDS follows the table. The procedure for backup are recognized and handled. For each selection type, as well as Failed or Incomplete, depending on the following... the default behavior is determined by adding controller values to the Agent settings in the Windows Registry on the computer on which the CA ARCserve Backup Agent for Microsoft SQL Server is Selected Standby (read-only, waiting to receive additional restores) Message Type: Error Message Type: Warning...
Microsoft SQL Guide
Page 97
...value entry is set to Incomplete. 4 = Error message posted. Add a new Key within "Common" called "Responses". 3. Job result is Selected Implicit Recovering (in the table and set to Failure. 3 = Warning message posted. In the Registry Editor, find the Registry Key "HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\CA ARCserve Backup\SQLPAAdp\Common" 2. Add new...for Job Result: Failure some other reason) Setting Name: Inaccessible Explicit Message Type: Error Job Result: Failure Setting Name: Inaccessible Implicit Note: SQL 2005 Point-In-Time Snapshots are strictly ignored.
...value entry is set to Incomplete. 4 = Error message posted. Add a new Key within "Common" called "Responses". 3. Job result is Selected Implicit Recovering (in the table and set to Failure. 3 = Warning message posted. In the Registry Editor, find the Registry Key "HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\CA ARCserve Backup\SQLPAAdp\Common" 2. Add new...for Job Result: Failure some other reason) Setting Name: Inaccessible Explicit Message Type: Error Job Result: Failure Setting Name: Inaccessible Implicit Note: SQL 2005 Point-In-Time Snapshots are strictly ignored.
Microsoft SQL Guide
Page 108
...FileGroups All databases have a primary FileGroup. Use FileGroups to manage database growth. Database data is a collection of tables, which allow you to store your Microsoft SQL Server databases, the following database fundamentals are comprised of only one log file (.ldf) per database though you ...performance, growth, and data allocation. data files and log files: ■ Data Files--Contain user data and metadata. - Though SQL Server supports single-disk systems, you create are stored in FileGroups at the transaction level required to the other documents usually stored outside...
...FileGroups All databases have a primary FileGroup. Use FileGroups to manage database growth. Database data is a collection of tables, which allow you to store your Microsoft SQL Server databases, the following database fundamentals are comprised of only one log file (.ldf) per database though you ...performance, growth, and data allocation. data files and log files: ■ Data Files--Contain user data and metadata. - Though SQL Server supports single-disk systems, you create are stored in FileGroups at the transaction level required to the other documents usually stored outside...
Microsoft SQL Guide
Page 109
Example Microsoft SQL Server Database Basics The following diagram illustrates a database with six user-defined Secondary Data Files (.ndf) grouped in parallel, to improve performance. You can create a table on three separate disks. Appendix C: Backup and Recovery Best Practices 109 Note also that any queries against the data in a table can then be allocated across the three disks in two user-defined FileGroups and stored on each FileGroup so that the Transaction Log and Primary Data Files are stored separately from user data.
Example Microsoft SQL Server Database Basics The following diagram illustrates a database with six user-defined Secondary Data Files (.ndf) grouped in parallel, to improve performance. You can create a table on three separate disks. Appendix C: Backup and Recovery Best Practices 109 Note also that any queries against the data in a table can then be allocated across the three disks in two user-defined FileGroups and stored on each FileGroup so that the Transaction Log and Primary Data Files are stored separately from user data.
Microsoft SQL Guide
Page 110
...up . You can perform a complete (full) or a differential backup and restore of the Filestream objects themselves. In SQL Server 2008, Filestream data is stored in regular data files, but a table can now backup catalogs with, or separate from, your database data. An individual full-text index created for a ... Database Basics Full-Text Search Catalogs With SQL Server 2005, Microsoft added full-text search enhancements that let you can back up or restored as text documents, images, videos or music files. A database can hold one or more tables, but are still treated as files in the ...
...up . You can perform a complete (full) or a differential backup and restore of the Filestream objects themselves. In SQL Server 2008, Filestream data is stored in regular data files, but a table can now backup catalogs with, or separate from, your database data. An individual full-text index created for a ... Database Basics Full-Text Search Catalogs With SQL Server 2005, Microsoft added full-text search enhancements that let you can back up or restored as text documents, images, videos or music files. A database can hold one or more tables, but are still treated as files in the ...
Microsoft SQL Guide
Page 111
... time. ■ You can individually restore the files in a database in which multiple FileGroups are using Microsoft SQL Server 2005 or later, you can partition tables across multiple FileGroups to speed query access times (queries scan part of the data instead of all of the ... and partial backups/restores can optimize your database performance. ■ If you separate tables with less expected traffic by multiple read/write devices. ■ Put different tables used . See the Microsoft SQL Server documentation for historical purposes can be assigned to a Read-only FileGroup. Consider ...
... time. ■ You can individually restore the files in a database in which multiple FileGroups are using Microsoft SQL Server 2005 or later, you can partition tables across multiple FileGroups to speed query access times (queries scan part of the data instead of all of the ... and partial backups/restores can optimize your database performance. ■ If you separate tables with less expected traffic by multiple read/write devices. ■ Put different tables used . See the Microsoft SQL Server documentation for historical purposes can be assigned to a Read-only FileGroup. Consider ...