A simple script to backup all filegroups within a database.
This will help in environments where filegroups and partioning are used to let a database span volumes for archive or performance reasons.
It will only work against databases using the FULL recovery mode.
1) Change the @destinationpath parameter at line 12 to reflect your environment.
2) Execute the script against the database you want to backup.
The script displays and executes the appropriate backup commands to generate separate backup files for each filegroup.
I've commented out line 23, where (in my environment) I have my non-clustered indexes stored in a filegroup called NCIndexes,
In non live environments I script these rather than back them up to save space.
Let me know what you think,