Wrong configuration of the network management database result in the alarm of the database space

Publication Date:  2012-09-13 Views:  162 Downloads:  0
Issue Description
In the operation of Windows, after the installation of the network management system, the management receives the alarm of database space
Alarm Information
Handling Process
Step 1: click “start”, select “process> Microsoft SQL Server>management enterprise”
Step 2: in the navigation tree of the “Microsoft SQL Server”, select “SQL Server group>(local)(Windows NT)〉database”
Step 3: click “MCDS”
Step 4: click right of mouse, select “property”
Step 5: in the dialog box of the “MSDB property”, click “data file”
Step 6: in the file list of the database, select “MCDB”
Step 7: double click “space distributed (MB)”change the value, for example: originally is “300”, enlarge to “1000”
Step 8: click “commit”
Step 9: log on the monitor terminal, click “database information”
Step 10: in the list of information, select “MCDB”, click right mouse, select “reflesh”, the color of this information turns from red to black, the alarm stops.
Root Cause
Configuration of the MCDB is wrong; the space distributed is too small, so the alarm comes. Log on the monitor terminal, click the “information of database”, found out that in the list of information, the “MCDB” is red.