Not backing up non-clustered indexes

paulopaulo Posts: 5
edited March 18, 2008 8:08PM in SQL Backup Previous Versions
Hi,

I was wondering if you have been tracking the discussion on this, it would be awesome to us if we could just backup the data and then just build the non-clustered indexes.

https://connect.microsoft.com/SQLServer ... kID=331220

http://www.sqlservercentral.com/Forums/ ... 263-1.aspx
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    Interesting. However, the backup data used by SQL Backup is provided by the SQL Server engine, not extracted by SQL Backup directly. For the backup to strip out the indexes, it will have to be supported by the SQL Server engine first.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.