Howtos / Articles

Database Recovery models for Microsoft SQL Server

Microsoft SQL server provides three recovery models; full, simple, and bulk-logged. Each have their benefits. The details of the three recovery models is outlined below. You will need to choose the best option for your scenario. For a production database that you need to be able to recover from, the best option will generally be the full recover model. Full recovery model: The full recovery model maintains the entire transaction log history up until the point where the database log…

Read more [...]

Fix Database Integrity Errors in Microsoft SQL Server

Sometimes you may encounter data integrity issues with one or more tables on a Microsoft SQL server. These errors may be found during a data integrity check using DBCC CHECKDB, or even via general use of the database. There are 3 options to correct the database integrity issues; safe repair, restore, and non safe repair (in that order). Its always good practice to take an extra backup before any of these commands are run (specifically the non-safe repair option). Safe…

Read more [...]

Automatically shrink database files in Microsoft SQL 2008

Microsoft SQL server 2008 has the ability to automatically shrink database files. By default this option is disabled. With automatic shrinking of database files turned on, the SQL server will periodically check the available free space within the database files, and will automatically shrink the files if needed. If your database has heavy use, it might be best to keep this option disabled to prevent performace degration. To check what the current auto shrink setting: SELECT DATABASEPROPERTYEX(‘<database_name>’, ‘IsAutoShrink’) Replace <database_name>…

Read more [...]

Microsoft SQL Server 2008 Express Limitations

Microsoft SQL Server 2008 Express Edition is a great database engine that is more than capable of handling most small business database requirements. There are however some limitations. The details below outline the main limitations in SQL 2008 Express Edition. (Note: This information is not for SQL Server 2008 R2. If you are after the details for the limitations on SQL Server 2008 R2, please check out Microsoft SQL Server 2008 R2 Express Limitations). CPU: 1 CPU (based on a…

Read more [...]

Microsoft SQL Server 2008 R2 Express Limitations

Microsoft SQL Server 2008 R2 Express Edition is a great database engine that is more than capable of handling most small business database requirements. There are however some limitations. The details below outline the main limitations in SQL 2008 R2 Express Edition. CPU: 1 CPU (based on a socket). No limit on cores. Memory: Maximum of 1GB for the database engine. (Note: SQL 2008 R2 Express Edition with Advanced Services includes reporting features, and has a limit of 4GB for…

Read more [...]



Page 1 of 212