Home Forums SQL Server 2008 SQL Server 2008 High Availability compressing read only file groups RE: compressing read only file groups
Dhruva_51
SSChampion
Points: 10521
More actions
February 27, 2014 at 2:00 pm
#1692881
i am not making the database into single user mode. I just leave the latest partition to read write and change the rest of the filegroups to read only. As paritions are based on date column, all new rows will be inserted into the latest file group.