Introduction :
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.
Usage :
1) Change the @destinationpath parameter at line 12 to reflect your environment.
2) Execute the script against the database you want to backup.
Output :
The script displays and executes the appropriate backup commands to generate separate backup files for each filegroup.
Note :
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,
r
Richard Doering
http://sqlsolace.blogspot.com
