April 5, 2002 at 9:35 pm
Okay, I'm as green as they get when it comes to administratering our SQL server; I have just completed MS's course on SQL 2000 Administration. What would be the #1 thing I need to ensure happens when I take over this job? I now know our server has never been backed up, this will be my first-thing Monday morning task. I'm a greenhorn here. Books? Procedures? I'm wingin' it here and asking for the experts help.
Thanks! Shairal
April 5, 2002 at 11:08 pm
April 6, 2002 at 8:25 am
Anything you read will apply as a general, yes #1 is backups. But all the books and all the information will not help you as much as experience. The #1 thing after backups of an existing system is to setup a test system and play with everything, get familiar with everything (esp. Profiler and Execution Plan reading as these are your best troubleshooters). Also get familiar with Enterprise Manager and study Current Activity and SQL Server Logs. Reading books and sites can help but always test what you learn.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 6, 2002 at 5:12 pm
make a backup, test a restore, and get this scheduled and straight.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply