June 30, 2006 at 8:22 am
I've been in charge of production and development SQL Server 2000 and 2005 servers for about 8 months now. Before that, my experience with SQL was extremely limited. While I am picking things up very quickly, and I have found numerous sites dealing with specific tasks, errors, etc, I was wondering if anyone knew a guide to my basic responsibilites in terms of keeping the servers running smoothly (in other words, how to do my job proactively, rather than reeling from error to error on a day-to-day basis)? Basically, everytime I think I've got something properly set up, something else pops up that I feel I should have been able to prevent or foresee . . . everything's smooth sailing right now, and I would like to use this opportunity to make sure it stays that way!
-- http://dbachman.blogspot.com
June 30, 2006 at 1:14 pm
If it was that easy there there would be no DBA's
However there are several good books on what your looking for.
The Microsoft SQL Server 2000 DBA Survival Guide
July 5, 2006 at 5:06 am
What I try to do is, make sure you know what your database has been doing. - Read the logs
make sure you know what your database's are going to be doing next week. - Try to calculate stats for growth of files, indexes etc
Make sure you have maintenance plans in place that are regualary backing up etc. And know when to get rid of (from your file system) the old backups and trn files.
Also a good idea to read the NT Event logs, some clues here about the system that your database is running on.
hope this helps
steve
July 5, 2006 at 3:44 pm
Have a look at these articles:
http://www.2000trainers.com/section.aspx?sectionID=2&tab=articles
There's also a SQL Server Newbies forum on this site that has some good links and references.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply