Checks whether the recovery model is set to the full recovery model instead of the simple recovery model for non-read only ...

SQL Server 2008

Checks whether the recovery model is set to the full recovery model instead of the simple recovery model for non-read only databases. The full recovery model enables point-in-time recovery. This reduces data loss if you must perform a recovery operation. Production databases should use the full recovery model, and schedule frequent transaction log backups to ensure recoverability with minimum data loss.

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 ... Checks whether the specified drive is FAT32 file system volume. Installing on a FAT32 file system is supported but not recommended ... Checks whether the SQL Server service can be restarted; or for a clustered instance, whether the SQL Server resource is online. ... Checks whether the value of the locks option is the default setting of 0. This enables the Database Engine to allocate and ... Checks whether Windows PowerShell is installed. Windows PowerShell is a pre-requisite of Microsoft SQL Server 2008 Express ...