No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

TNCOMMONDB database is abnormal status due to space of databse is low

Publication Date:  2012-07-25 Views:  27 Downloads:  0
Issue Description
Customer faced problem of TNCOMMONDB database status in database monitor is abnormal. 
      
Alarm Information
null
      
Handling Process
Steps to expand databse capacity: Check attachement
1. Click Start button on server -> All programs --> Microsoft SQL Server --> Enterprise Manager.
2. Expand Microsoft SQL Server till find TNCOMMONDB database in left window.
3. Right click TNCOMMONDB databse and choose properties. From window appeared click data files tab change the space allowed to be 40. 
4. And in Transactions log, chang Space allowed to be 25
 
Root Cause
After check found total assigned data space is 100 MB. And used data is 87%. Which need to be expand database capacity . 
      
Suggestions
Note : Don't close auto expansion function to not cause other problems.       

END