• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

Maintenance tasks for Sql Server Express 2008

Hi
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.
thanks
Paul
0
LearningToProgram
Asked:
LearningToProgram
1 Solution
 
Tony303Commented:
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...

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_28261867.html


After that the DBCC CheckDB is the process that you need to do schedule to run on a regular basis.
See...
http://social.msdn.microsoft.com/Forums/en-US/53dd39a4-8920-4415-9cb1-7d3aa89ea601/what-is-compact-and-repair-sql-database?forum=sqlexpress

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....
http://support.microsoft.com/kb/2019698

I hope this gets you started.

T
0
 
LearningToProgramAuthor Commented:
thanks. that got me started
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now