What are the challenges you face when working across database platforms? Take the survey
Options

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

Comments

  • Options
    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
Sign In or Register to comment.