We have a SQL job that runs each night to perform a data extract and import function. The job performs against a snapshot and copies from several tables in a serial loop. Today the job reported the following error:
Starting copy... SQLState = 37000, NativeError = 952 Error = [Microsoft][SQL Server Native Client 11.0][SQL Server]Database 'SnapDW' is in transition. Try the statement later.
This did not occur near the time of the Snap recreation job. Several of the table data extracts (that point at the same snap) prior to this one worked fine. And the job appeared to recover for the next table data extract.
I'd like to find out what caused this job to fail. Any help on places to look would be helpful as it doesn't appear that there is any reason for the snapshot to have been offline.