Category Archives: Backup & Recovery

In this post, I’m going to demonstrate how to take backup of database without considering non clustered indexes. Before describing how to eliminate index data from backups, it’s first important to point out that a non clustered index contains simply a copy of the rows from its associated table, sorted differently by the index’s keys toContinue reading “Backup and Restore Database without non clustered indexes”