February 3, 2009 at 9:57 am
I've just installed sql server 2005 for my company. I have various tasks to do, which include duties such as maintaining the system, monitoring data quality and producing reports. Can an expert DBA advise me what are the critical issues to take note of before and during undertaking these tasks? And in terms of maintatining the system and monitoring the quality of data, what issues should I be aware of and if needs be address or prevent occurances of these issues?
Many Thanks
Justin
February 3, 2009 at 10:44 am
Hi Justin
I am not an Expert DBA, but you have mentioned some tasks that are critical, and has to be taken care, i would start with what you have mentioned on your post 🙂
Cheers
February 3, 2009 at 10:53 am
Backups, first, last & always. You can't be paranoid enough.
Also, are your databases in simple recovery mode or full? If full, you need to come up with a log backup plan in addition to the full backups (and incrementals if needed).
Index defragmentation, statistics maintenance, consistency checks (which should be run before backups).
That'll keep you busy for the next week or two. Come back for more.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 4, 2009 at 3:54 am
It's in full recovery?
February 4, 2009 at 4:17 am
wed9114 (2/4/2009)
It's in full recovery?
Make sure you have Full-Backup and Transactional Log back-Ups running, work out how much data loss the company can handle in a disaster and time your log back-ups to match this.
Also Security is very important make sure you have the users and permissions set up for your needs
February 4, 2009 at 6:36 am
For a bare-bones introduction to backups, check this out[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 5, 2009 at 7:31 am
See this post on SQLServerCentral;
http://www.sqlservercentral.com/Forums/Topic646091-146-1.aspx#bm648916
I posted my "Post Installation Steps" doc on it.
It's not all inclusive, but a good start.
Tim White
February 5, 2009 at 9:01 am
cheers!:)
February 5, 2009 at 9:02 am
Cheers!:)
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply