Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unanswered: DB Health Check Script

    Hi,

    I am an Oracle DBA looking for a SQL Server Health Check script that will tell me the overall status of a database/server. Does anyone have anything like this? I'll be more than happy to share any scripts I already have for Oracle.

    Thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Check out the system stored procedures already available, such as sp_Helpdb and sp_spaceused.

    blindman

  3. #3
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    DBCC checkdb and dbcc checktable help as well. DBCC stands for database consistency checker. Type in DBCC in BOL (Books-online) and it will show you a bunch of commands that may help you.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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