May 17, 2022 · In this blog, we discuss different strategies for archiving data within a database. These strategies are independent of and not related to high availability and disaster recovery …

Archiving old data in SQL is vital for maintaining high performance and managing database storage effectively. In this post, we will guide you through various methods to archive old data …

Mar 6, 2024 · This tip explores a better, more direct, and more optimized method for moving or archiving data in SQL. This method does not require transaction control as it consolidates the …

Feb 2, 2026 · Learn how to archive old SQL data safely with table and partition layouts, batch moves, foreign keys, and growth planning for queryable history.

Feb 20, 2026 · This guide provides step-by-step instructions for archiving old data in SQL Server by using table partitioning and dbForge Studio for SQL Server tools, such as SQL Editor, …

Jun 28, 2025 · In this article, we will delve into the best practices for SQL Server data archiving, providing a comprehensive guideline for safely and efficiently archiving your data.

May 7, 2024 · Write SQL queries within the stored procedure to identify the data that meets the archiving criteria. This could involve selecting records based on date ranges, access …

Aug 16, 2019 · Script showing how to efficiently archive data based on a date range. Rows are archived in batches to prevent blowing up the SQL Server Log File.

Nov 16, 2022 · Once you know how long you need to retain data, you can start planning. I’ll review two approaches: 1) partitioning (for Enterprise Edition customers) and 2) separate …

Nov 8, 2024 · Archiving old or obsolete data is an effective strategy to maintain optimal performance. In this post, we’ll explore how to archive old transactions from a SQL Server …