Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Unanswered: How check database properties?

    Hello, Everyone:

    There are some databases in a SQL Server. How to check,
    1. User database numbers
    2. Backup plan
    3. Configuration
    4. User database size
    5. Nightly process

    Thanks a lot


  2. #2
    Join Date
    Nov 2002
    sp_helpdb <DBname> should give you a broad overview of the database.

    For the rest of the stuff you can use Enterprise Manager.

Posting Permissions

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