• quackhandle1975 (11/20/2014)


    Hi Robust,

    You can create a file group for each monthly partition, so you would need 36 partitions for 3 years. You can setup an automated job that will switch the partition out and archive your data. I am not sure what you mean messing up the bacuk strategy, you can set a filegroup to be read only. You need to ask yourself why you would put certain tables in filegroups, it is for performance, VLDBs, indexing etc.

    Try this link from Brent Ozar[/url], to get you started.

    qh

    Hi quackhandle1975,

    As I mentioned before, I have the option to create new filegroup for each new partition or rotate existing filegroups once they become available after removing the oldest partition. To be able to write again to the old filegroup (after it was made read-only) I need to perform a full backup of the database, as switching the filegroup from read-only to read-write will invalidate the previous filegroup backups.