As far as I am concerned, we need to break up our big database (more than 500 GB) into a series of filegroups for better performance, easier management and faster disaster recovery. – Filegroup with current active data – Filegroup with old and obselete data First of all, create a series of filegroup, and then …Continue reading