Maintenance tasks for Sql Server Express 2008

I've built a multi-user system with Access 2010 as the front end and Sql server express 2008 as the backend
I've got a question:
 What can I do in Sql Server express that is comparable to a "compact and repair" in Access ?
I have Sql server Management Studio, but I'm not very proficient with it, so I would appreciate  detailed instructions on how to do this.
Who is Participating?
Tony303Connect With a Mentor Commented:
Hi Paul,

What you need to do prior to your "compact and repair" equivalent is to work out a DR plan that includes a backup of the Database and the log files. The treatment of the log files and backup etc. of same determines the growth of the log file. If you look here or on Google, there are zillions of articles about drives filled up because of log files growing.

Here is an EE article I participated in regarding this...

After that the DBCC CheckDB is the process that you need to do schedule to run on a regular basis.

Scheduling will require you to setup SQL agent and setup a SQL job to run.
The books on line article here will help with the backup, you can add a task before the backup to do the DBCC CheckDB....

I hope this gets you started.

LearningToProgramAuthor Commented:
thanks. that got me started
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.