Skip to main content
October 15, 2024

Shrink Database

  • October 15, 2024
  • 1 reply
  • 0 views

Hello,

What happens to the OneStream application when a database shrink is performed? Are there any risks associated with this?

Thanks

 

1 reply

October 15, 2024

When a database shrink is performed, it is reclaiming any un-used space in the database that is marked as "Allocated" but is not fully in use.  You would want to make sure that users are out of the system while a database shrink is being performed, as this will have an impact on performance in the OneStream application while it is running.  A re-index is also normally run following the shrink process.