How to create History Table in another Filegroup - SQL Server?
Looking to implement SQL Server Temporal tables, but prefer to store the History table on a separate filegroup. Unable to see any way to do this. How do I specify an alternate Filegroup for the History table?
How to create History Table in alternate Filegroup.
1. Versioned table must have two attributes of type Datatype2. One marked as ‘Start’ and second as ‘End’. Also, both marked ‘Not Null’.
2. Next, go to ‘Temporary Table Properties’ tab of ‘Entity Properties’ dialog, and check-mark ‘Enable System Versioning’.
3. On same tab, under ‘History Table Name’, specify the name of the new table with schema prefix, and click ‘Create’.
