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>Search

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:  69 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