SQL Server DB Environment documentation

  • I am relativley new to the DBA role.

    Can anyone suggest a resource which will help me determine the type of information to put into a document describing the DB environment? If possible, I would like to find a document I could customize for my company. I imagine it should include a profile of each DB server, DB Maintenance Plans, type of security validation, etc.

    Thank you for your time and consideration.

    Mike

  • A great suggestion for something to write about 🙂

    I don't have a resource, but the basics would be the same for each server:

    1. hardare

    2. software, including current settings (SPs, what's installed).

    3. Security - Server settings, who has rights, roles, set.

    4. databases- what's out there and their properties

    5. backup plans

    6. jobs scheduled and running

    7. standards

    8. change management.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • Thank you, Steve. That gives me a start.

    Mike

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply