Search code examples
sqlsql-serverdatabase-administration

Data Retention in SQL Server

I need to implement data retention in our SQL Server database. Other than archival tables, do we have any other options? Please suggest

Solution

  • The answer depends on the nature of the data (size/need for immediacy/business case) a bit but a few common patterns for retention include:

    1. archive tables
    2. aggregation tables
    3. server replication
    4. scheduled instance backups
    5. advanced magic (partitions/column storage etc)

    Without knowing the data or objectives a case could be made for any of these.