Help with Administration on SQL2000

  • Hi All.

     

    I hope that you could help. I am trying to put a list daily, weekly and monthly tasks to check on a SQl server box. ie. Hard Drive Space Data File Log File ect. Hopefully to try avoid problems before they happen. I would appreciate anyones input into what they look for in event log's ect.

    Thanks in advance

    Scott

  • I use a few scripts myself to check these things. I check for the server disk space details, services, database status, jobs and thier status etc. This was done with a batch file and use that every day.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Thanks for your input Sugesh

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

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