Index of backup4/15/2023 ![]() So you'd have a timing issue where sometimes the backup has the indexes, and sometimes it doesn't. ![]() ![]() If it were such an ETL job doing this, for example, some loads may be taking so long that they aren't complete when the backup ends. Look for other types of activity that occur on the server leading up to the backup window. There may be an ETL job that removes indexes before a data load, and then creates the indexes again after the load is complete. It's most probable that the indexes did not exist when the backup completed. Such a feature would be nice as it would result in much smaller backups, but Microsoft states that there are many hurdles to adding such a feature (see here). There is no setting that allows indexes to be omitted from the backups or restores.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |