PiMané (3/7/2013)
GilaMonster (3/7/2013)
Really? Have you tried that?Not with indexes... just some more "sensible" data (accounts, orders, ...) and "fixed" data (like countries, regions, currencies, ...).
You might want to try that 'don't back up the indexes' idea before you implement that in production. Don't want an unpleasant surprise...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability