is it possible to use the MSSQL "BACKUP DATABASE" in a way that will not include the indices, even if they are stored in the same file group as the table itself? Or would I have to move the indices to another filegroup first? Or is there a reason to include indices in the backup?
Tell me more
×
Server Fault is a question and answer site for
professional system and network administrators. It's 100% free, no registration required.
|
There's no backup command without index feature (it's often requested), but Brent Ozar documented his approach here: http://www.brentozar.com/archive/2010/02/how-to-really-compress-your-sql-server-backups/ |
|||
|
|
