NOLOCK
Publicado por nancy (8 intervenciones) el 26/01/2005 21:35:05
Hola,tengo un problema, en SQL hago un backup de una base de datos mediante un job, el backup se realiza, pero el job termina con un error. El mensaje de error es el siguiente:
Executed as user: NT AUTHORITY\SYSTEM. ...ercent backed up. [SQLSTATE 01000] (Message 3211) Processed 168 pages for database 'solicitud_material', file 'solicitud_material_Data' on file 1. [SQLSTATE 01000] (Message 4035) 100 percent backed up. [SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'solicitud_material', file 'solicitud_material_Log' on file 1. [SQLSTATE 01000] (Message 4035) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE... The step failed.
Antes utilizamos SQL 7 pero se migró a SQL 2000, antes no daba problemas y ahora sí. He estado averiguando y me parece que tiene que ver con el isolation lavel, pero no se como se maneja, no se si es a nivel de base de datos, a nivel de tablas, etc.
Espero me puedan ayudar.
Gracias
Executed as user: NT AUTHORITY\SYSTEM. ...ercent backed up. [SQLSTATE 01000] (Message 3211) Processed 168 pages for database 'solicitud_material', file 'solicitud_material_Data' on file 1. [SQLSTATE 01000] (Message 4035) 100 percent backed up. [SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'solicitud_material', file 'solicitud_material_Log' on file 1. [SQLSTATE 01000] (Message 4035) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Could not continue scan with NOLOCK due to data movement. [SQLSTATE... The step failed.
Antes utilizamos SQL 7 pero se migró a SQL 2000, antes no daba problemas y ahora sí. He estado averiguando y me parece que tiene que ver con el isolation lavel, pero no se como se maneja, no se si es a nivel de base de datos, a nivel de tablas, etc.
Espero me puedan ayudar.
Gracias
Valora esta pregunta


0