SQL SERVER – Microsoft SQL Server 2000/2005 Management Pack Download

The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details, possible causes, and suggested resolutions. The Management Pack discovers Database Engines, Database Instances, and Databases and can optionally discover Database File and Database File Group objects.

Feature Summary:

• Active Directory Helper Service
• SQL Server Agent
• Backup
• Databases and Tables
• DBCC
• Full Text Search
• Log Shipping
• Clustering
• DB availability
• Replication monitoring
• Agent jobs
• Backup Query Engine
• Replication
• Web Assistant
• SQL XML

Download Here

Reference : Pinal Dave (https://blog.sqlauthority.com)

Database, SQL Download, SQL Utility
Previous Post
SQL SERVER – Popular Articles of SQLAuthority Blog
Next Post
SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value

Related Posts

3 Comments. Leave new

  • Michael Harmon
    April 1, 2008 9:36 pm

    How is this tool used?

    Reply
  • Hi Pinal,

    Will you be able to tell me how can I copy my live production database into a development server and keep the development data always current? I do not wish to use replication as the developers find it too hard to change the db structure at a later point if ever required. You assistance is much appreciated. Thank you!

    Reply
  • Hi Pinal,

    I am converting database from 2005 to 2000 as per your guidance as follows:

    1. Converting Compatibility as follows:
    ALTER DATABASE ABC SET SINGLE_USER
    EXEC SP_DBCMPTLEVEL ABC , 80;
    ALTER DATABASE ABC SET MULTI_USER
    2. Taking the ABC Bakcup Using Wizard.
    3. Now while Restoring the ABC.bak i got Following Error..
    in Aquery Analyzer of 2000

    Server: Msg 3205, Level 16, State 2, Line 1
    Too many backup devices specified for backup or restore; only 64 are allowed.
    Server: Msg 3013, Level 16, State 1, Line 1
    RESTORE FILELIST is terminating abnormally.

    I need your Help ASAP.

    Wiaiting for you Help.

    Thanks,
    Raj
    raj181081@gmail.com

    Reply

Leave a Reply