SQL Admin Checklist - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Admin Checklist

Author

Topic

chrissy
Starting Member

17 Posts

Posted - 2002-01-14 : 01:28:06

I recently came upon O'reilly's Oracle DBA Checklist Pocket Reference (http://www.oreilly.com/catalog/ordbacheck/) and thought that it was great. I wondered if SQL Server had something similar and I have not found it yet. Could anyone point me in the right direction? I've looked in BOL, Inside SQL Server 2k, SQL 2k Resource kit, Administrators companion sqlmag.com, sqlteam.com, msdn and Google.

O'reilly's book covered what to do daily, weekly, and monthly. It also gave a checklist for improving performance, backup and restore (!!), and other things..

anyone have any suggestions?

Nazim
A custom title

1408 Posts

Posted - 2002-01-14 : 02:18:44

Hi there,

Firstly, IMO the Most Common things a DBA does whether hez an Oracle or a Sql Server. like Backups,Restores,Managing Indexes, Managing Users, Roles, Logins..... . the only thing you have to differentiate is how you do it in Sql Server. Relatively its very easy Managing a Database with Sql Server.

Follow this Link http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=10422

btw, Sql Server provides a Database Maitenance Wizard try using it too, i personally have been using it without any problems, though it its always better you hardcode and make a job of it and run it periodically.
it should help you.

----------------------------------
"True love stories don't have endings."

Edited by - Nazim on 01/14/2002 02:43:46

mphelps
Starting Member

12 Posts

Posted - 2002-01-14 : 02:44:38

found this on the Microsoft Site !
Should be useful

SQL Server 2000 Operations Guide

Are you responsible for keeping your organization's database systems up and
running? Are you the one they call in the middle of the night if the
database server is down? If so, the SQL Server 2000 Operations Guide is for
you.

To manage SQL Server in a day-to-day environment, an operations team needs
to perform a wide variety of procedures, including server monitoring,
backup, verification of scheduled events, capacity planning, and developer
and end user support. This guide includes instructions for the procedures
along with steps for dealing with unresolved issues in a timely manner.

The content of the Operations Guide draws from the knowledge and best
practice guidelines from Microsoft Consulting Services (MCS), Microsoft’s
Internal Technical Support Group, and the SQL Server Development Team.

To download individual chapters, click the links for those chapters in the
following list:

Chapter 1: Introduction
Chapter 2: Change, Configuration, and Release Management
Chapter 3: Security Administration
Chapter 4: System Administration
Chapter 5: Monitoring and Control
Chapter 6: Capacity and Storage Management
Chapter 7: Problem and Incident Management
Chapter 8: Service Management

To download all chapters at once, click the following link:

[url]http://www.microsoft.com/technet/prodtechnol/sql/maintain/operate/opsguide/sqlopall.exe[/url]

quote:
I don't suffer from insanity, I enjoy every second of it

chrissy
Starting Member

17 Posts

Posted - 2002-01-14 : 13:45:56

Thanks so much, you guys. I searched this forum but didnt come up with anything. Wrong keywords i guess.

Both of those URLs are great resources. Thanks again!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources