Steve Jones - SSC Editor (1/18/2011)
20GB, as Grant mentioned, isn't large. However if you are considering this to be a small system that is growing, I would split the table to a separate filegroup and then run filegroup backups.Make sure that you practice restoring so that you understand how to restore a filegroup separately from another.
Excellent point. Yes, practice doing the restores if you're deviating from a simple standard full backup.
Of course, you should practice restoring the full backup too.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning