cancel
Showing results for 
Search instead for 
Did you mean: 

Advanced Reporting BigDataInsightUC database free disk space running out or low on SQL server

Highlighted
Community Manager

Advanced Reporting BigDataInsightUC database free disk space running out or low on SQL server

Available disk space is getting dangerously low towards the end of each month or runs out completely and reaches 0MB of free space before the end of each month causing data gaps in reports.

What can we do to avoid data gaps in reports and bring free disk space back to safe levels?

 

2 REPLIES 2
Community Manager

Re: Advanced Reporting BigDataInsightUC database free disk space running out or low on SQL server

Scenario:

Available disk space is getting dangerously low towards the end of each month or runs out completely and reaches 0MB of free space before the end of each month causing data gaps in reports.

 

Note that the Advanced Reporting ETL job is designed to automatically purge file groups that are older than the retention period. The ETL does this within the first few days of each month.

 

Question:

What can we do to avoid data gaps in reports and bring free disk space back to safe levels?

 

Answers:
1. The safest and supported way is to reduce the retention period by re-running the deployment script setup.bat pointing it the existing database, selecting 'U' option (Use existing database), then entering a smaller number of months of retention and then relying on the ETL to remove old file groups/partitions automatically at the first few days of the month. See this post for running the setup script to change retention:
https://community.ir.com/t5/Unified-Communications/In-Advanced-Reporting-can-I-change-how-many-month...

 

2. Alternatively (Requires SQL knowledge) move file group files to another drive (take the database off line, move files, alter database file filenames to the new path, bring database online).

* Make sure there is a complete full backup of the database before attempting this.

 

HTH

 

Community Manager

Re: Advanced Reporting BigDataInsightUC database free disk space running out or low on SQL server

Follow on Q&A:

 

Question:
Can the oldest file group within the retention be deleted before the end of the month?

 

Answer:

The short answer is No. There is currently no supported feature or procedure to do this. Attempts to remove a file group that is still within the retention period have failed and resulted in having to restore the whole databse from backup (and incur data gap from the time that the backup was taken).

 


Question:

How can this scenario be avoided pro-actively?

 

Answer:

This post provides a formula to help anticipate how much disk space is required.
https://community.ir.com/t5/Unified-Communications/disk-drive-sizing-for-Advanced-Reporting-BigDataI...

HTH

Webinar: The Journey to Microsoft Teams - Readiness Phase (part 2)

Having looked at the planning phase in session one of this series, we will turn our focus to the readiness phase. The all important technical capabilities assessment, ensuring the network, endpoints and users are adequately prepared for the move.

Hear first hand from IR's Global Head of Information Systems and Technology, Jason Schwendinger, on how he has been tackling these issues.

Join webinar