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.

  • Database 'SnapDW' is in transition seems like the database was recovering. Is 'SnapDW' the snapshot of the database ? You have to check the sql server error log to find out what exactly happened. – Kin Shah Jan 22 '16 at 15:01
  • @Kin - Sorry I should have included that above. I looked in the sql server logs and the sql agent logs on that instance and I didn't find anything. some backups occurred but not around the time of the error. – Lumpy Jan 22 '16 at 15:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.