JeremyE (1/7/2011)
A big win for Litespeed is the ability to do object level restores. Restoring a single table or proc is much easier than restoring an entire TB sized database and extracting the single table.
As far as single table, I'll give you that.. Out hosts Red-Gate has a tool that lets you mount the backup like a database and access it directly, very cool..
As far a sproc restore, I'm taking the position that if you have to go to the backup to get source code, that code control is likely an issue in your organization. The database is a recipient of the code not a storage location.. Sorry..
CEWII