I was wondering if it is necessary to perform maintenance tasks on the SQL Express 2005 instance associated with SCE 2007? I know that the database is configured to perform grooming, and other data cleanup, however are tasks such as Index Rebuild's/Reorg's, statistic updates, and integrity checks a good idea? I was looking to use ExpressMaintenance to provide the mechanism to perform these tasks, but I just want to make sure it is necessary before creating the scheduled tasks.

Hello, It is not necessary if there's not any performance issue on the DataBase. You can configure the database grooming by following the thread below: Automatic database grooming configuration http://social.technet.microsoft.com/Forums/en-US/systemcenteressentials/thread/0adce9ed-6d3b-47fe-b3d8-79e4a1dfa465 Besides, I would suggest the following article from Kevin Holman's Blog: Understanding and modifying Data Warehouse retention and grooming http://blogs.technet.com/b/kevinholman/archive/2010/01/05/understanding-and-modifying-data-warehouse-retention-and-grooming.aspx Hope it helps, Yog Li -- Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Thank you for the response. Besides the removal of data what other functions does SCE perform on the DB? Does the application perform tasks such as integrity checking?

Hello, To edit "Database Grooming Settings", Essentials will only remove the data that have expired. There's not a task to check the database integrity. Thanks,Yog Li -- Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

I would have to disagree with the statement "It is not necessary if there's not any performance issue on the DataBase." This is entirely the point of running tasks such as DBCC or a index reorg or rebuild. Personally I'm somewhat disappointed that for a product targeted at SMB's that such tasks are not done by default on a scheduled basis. I'm curious to know what other individuals are performing for SQL maintenance on their SCE SQL Express Instances.

Thanks Jose, That was the information that I was looking for.