Checks whether the database has suspect database pages. A database page is set suspect by error 824. This error occurs when a logical consistency error is detected during a read operation, which frequently indicates data corruption caused by a faulty I/O subsystem component. When the SQL Server Database Engine detects a suspect page, the page ID is recorded in the msdbo.dbo.suspect_pages table. This is a severe error condition that threatens database integrity and must be corrected immediately. Best Practices Recommendations: * Review the SQL Server error log for the details of the 824 error for this database. * Complete a full database consistency check (DBCC CHECKDB). * Implement the user actions defined in MSSQLSERVER_824.
Checks whether the blocked process threshold option is set lower than 5 and is not disabled (0). Setting the blocked process ...
Checks whether the computer is a domain controller. Installing SQL Server 2008 on a domain controller is not recommended. ...
Checks whether the CPU architecture of feature(s) you are trying to remove is different than the CPU architecture of this ...
Checks whether the CPU architecture of feature(s) you are trying to upgrade is different than the CPU architecture of this ...
Checks whether the database has suspect database pages. A database page is set suspect by error 824. This error occurs when ...
Checks whether the dbo or a db_owner is assigned to a fixed server sysadmin role for databases where the trustworthy bit ...
Checks whether the edition of the selected SQL Server instance is supported in this SQL Server edtion downgrade scenario. ...
Checks whether the open objects server option is set to 0, the optimal value on instances SQL Server 2000. Using a nonzero ...
Checks whether the recovery model is set to the full recovery model instead of the simple recovery model for non-read only ...