Results 1 to 3 of 3

Thread: Documentation

  1. #1
    Join Date
    Jul 2004

    Unanswered: Documentation

    What information should I be documenting about a server (SQL) and about the databases found on that server. I was task with this job. Please help.



  2. #2
    Join Date
    May 2003
    Rochester, NY
    Number one item would be the 'sa' password if your job is to manage the server. Since SQL Server does not allow you to see passwords, only change
    them, this would be the most critical item. Most everything else can be gleaned from looking at the existing database(s) and processes.

  3. #3
    Join Date
    Apr 2004
    Kansas City, MO
    I would document out your backup/recovery/tape backup/disaster recovery as completely as possible.

    It's always nice to have as part of your data dicitionary what the general purpose is of each database as well. In addition, I like to keep a "server log" that describles what's on it, when patches were applied, etc. This is all more for management thought than anything else.

    Were you given any details about what they're expecting? Your description is rather vague.
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts