Home / server / Questions / 181761
Accepted
JonDrnek
Asked: 2010-09-17 03:57:20 +0800 CST

Basic SQL Server Administration

  • 772

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?

sql-server

3 Answers

  1. Best Answer
    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.
    • 2

  2. google "sql server administration for beginners"

    also, have a look here for books to read BrentO

    • 0

  3. 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.

    • 0