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.
• Active Directory Helper Service
• SQL Server Agent
• Databases and Tables
• Full Text Search
• Log Shipping
• DB availability
• Replication monitoring
• Agent jobs
• Backup Query Engine
• Web Assistant
• SQL XML
Reference : Pinal Dave (https://blog.sqlauthority.com)
How is this tool used?
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!
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.