---
title: "Database Properties (ChangeTracking Page) | Microsoft Docs"
ms.custom: ""
ms.date: "01/07/2016"
ms.prod: "sql-server-2016"
ms.reviewer: ""
ms.suite: ""
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "article"
f1_keywords: 
  - "sql13.swb.databaseproperties.changetracking.f1"
ms.assetid: 9b929640-bc62-449b-9b06-b5a77b8cf372
caps.latest.revision: 13
author: "BYHAM"
ms.author: "rickbyh"
manager: "jhubbard"
---
# Database Properties (ChangeTracking Page)
  Use this page to view or modify change tracking settings for the selected database. For more information about the options available on this page, see [Enable and Disable Change Tracking (SQL Server)](../../relational-databases/track-changes/enable-and-disable-change-tracking-sql-server.md).  
  
## Options  
 **Change Tracking**  
 Use to enable or disable change tracking for the database.  
  
 To enable change tracking, you must have permission to modify the database.  
  
 Setting the value to **True** sets a database option that allows change tracking to be enabled on individual tables.  
  
 You can also configure change tracking by using [ALTER DATABASE](../../t-sql/statements/alter-database-transact-sql.md).  
  
 **Retention Period**  
 Specifies the minimum period for keeping change track information in the database. Data is removed only if the **Auto Clean-Up**value is **True**.  
  
 The default value is 2.  
  
 **Retention Period Units**  
 Specifies the units for the Retention Period value. You can select **Days**, **Hours**, or **Minutes**. The default value is **Days**.  
  
 The minimum retention period is 1 minute. There is no maximum retention period.  
  
 **Auto Clean-Up**  
 Indicates whether change tracking information is automatically removed after the specified retention period.  
  
 Enabling **Auto Clean-Up** resets any previous custom retention period to the default retention period of 2 days.  
  
## See Also  
 [ALTER DATABASE (Transact-SQL)](../../t-sql/statements/alter-database-transact-sql.md)   
 [CREATE DATABASE (SQL Server Transact-SQL)](../../t-sql/statements/create-database-sql-server-transact-sql.md)