I have a DTS package in SQL Server 2000 that copies data from one database to another. The copy indexes option is checked. For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over. At first it was maybe once or twice a month it would happen and now it is almost every other day it happens. Please help!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!