---
title: "Discussion on \"Successful 2.5 TB Database Shrink\" | Hashnode"
description: "Discussion on \"Successful 2.5 TB Database Shrink\". Step-by-step guide to safely shrinking a 2.5 TB SQL Server database online without downtime, solving the 32-bit arithmetic overflow error (Msg 8115)."
url: "https://hashnode.com/posts/successful-2-5-tb-database-shrink/6a223b434c3445f06ddacd36"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Successful 2.5 TB Database Shrink](https://datasanare.hashnode.dev/successful-2-5-tb-database-shrink?utm_source=hashnode&utm_medium=feed)

Step-by-step guide to safely shrinking a 2.5 TB SQL Server database online without downtime, solving the 32-bit arithmetic overflow error (Msg 8115).

Jun 5 · 10 min read · datasanare.hashnode.dev  
Read the article

-   [#sql-server](https://hashnode.com/tag/sql-server)
-   [#databases](https://hashnode.com/tag/databases)
-   [#performance-tuning](https://hashnode.com/tag/performance-tuning)
-   [#data-shrink](https://hashnode.com/tag/data-shrink)

## Written by

[Deka OK](https://hashnode.com/@qorino)

@qorino · Jakarta, Indonesia

  
[View profile](https://hashnode.com/@qorino)

SQL Server, Database Administration, T-SQL, Database Performance, Developer Experience.

Enterprise Database Administrator and Developer with over 15 years of hands-on experience handling production infrastructure, Always On clusters, and massive database migrations. Bridging the gap between hardcore DBA protocols and Data Analytics to optimize business intelligence systems. Founder of DataSanare, blogging about query tuning, zero-trust backend security, and database post-mortems.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.