web 2.0

Monday, June 27, 2011

CRM 2011 Basic Database Maintenance & Backup

Creating a proper Database maintenance plan is essential in any CRM environment, it will ensure that your system can be recovered in case of any outages and you will ensure that you are getting the best performance out of it. In case you are not familiar with how to create a maintenance plan in Microsoft SQL please check this video. I will be listing below what to include in your maintenance plan.

Databases you should include in your maintenance plan
  • The MSCRM_CONFIG database.
  • Each Organization_MSCRM database you have in your deployment.
  • The SQL Reporting Services databases: ReportServer and ReportServerTempDB.
  • The master and system Databases.
Tasks you should include in your maintenance plan
  • Check Database Integrity
  • Shrink Database
  • Reorganize Index
  • Rebuild Index
  • Update Statistics
  • Backup Database (Full)
  • Maintenance Cleanup Task
In a nutshell, Indexes are one of the ways that SQL server quicly locates information stored in a database table so it is important that indexes are updated to take into account new records or records that have been removed. SQL server also maintains statistics on each database to help it calculate the most efficient way to perform queries and other functions. Updating statistics will improve your SQL Server's efficiency. 

Important Note
Keep in mind that the maintenance plan impacts your CRM server performance so you need to schedule or launch the plan during off-peak usage hours.


No comments:

Post a Comment