Monday, July 17, 2017

Resolving Database Size Issues

Our database is typically very small.  Therefore, we will display a warning message if the database size grows to an atypical size (by default > 6gb).  This is often caused by a drive space shortage.  Each night we make a backup of the database and do a shrink.  If there is not enough space to perform the task it cannot complete.
The steps to resolve are as follows.

1. Ensure there is sufficient disk space. (Ensure that the hard drive was built per spec at 100gb to start with).
    You should have at least 1.5x the current database size for available space before attempting the backup.

2. Backup the database.  Once you initiate this backup, wait approximately 5 minutes before continuing to the next step.

3. Shrink the database.  Once you initiate the shrink, it may take up to 10 minutes to complete.

No comments:

Post a Comment