Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

We just recently moved an internal database from access to SQL Server Express 2008. Other then taking backups and applying patches are there basic administration tasks that I should be doing?

share|improve this question

3 Answers 3

up vote 2 down vote accepted
  1. Keep an eye on disk space.
  2. Related - don't have your data and log files on the same partition as each other or the OS.
  3. If you're running in Recovery Mode = Full, you also need to do transaction log backups.
  4. There's a lot of performance analysis that you can do, if you need to. You might not need to.
share|improve this answer
    
Also I would suggest to limit memory usage dedicated for SQL Server as by default it is unlimited. So SQL Server can take much more memory that the amout it really needs for your database. –  Danilo Brambilla Sep 16 '10 at 13:50
    
SQL Server Express is limited to using 1GB of memory, so nothing to worry about there. –  Evan M. Sep 16 '10 at 14:57
    
This is incorrect for Express, it's limited to 1 GB. However, if you were running SQL Server non-Express on a machine that was also doing non_SQL things, you would want to limit the SQL memory. That's generally why you want SQL on a dedicated machine. –  mfinni Sep 16 '10 at 15:04

google "sql server administration for beginners"

also, have a look here for books to read BrentO

share|improve this answer

The pdfs from redgate are pretty good - lots of things you can look at.

Your three main things to look after are...

1.Backups

2.Recovery

3.Security

Test a backup to another database name and make sure it works for you. Make sure you are notified when the backups fail.

You'll want to do periodic maintenance on the indexes too. I prefer this script - http://ola.hallengren.com/

This type of stuff is a bit of a pain in sql express since there is no agent to run jobs. You'll need to use the windows task scheduler or another tool to schedule .bat's to run.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.