Forums Últimos mensajes - Powered by IBM
 
Tags Palabras claves

Resultado de plan de mantenimiento

29/07/2008 - 16:21 por Geovanny Quirós C. | Informe spam
Ayuda Hacer una pregunta
Éste es un mensaje de varias partes en formato MIME.
=_NextPart_000_0050_01C8F154.15EE3A20

Hola grupo,
deseo implementar un plan de mantenimiento en SQL2000, el asunto es que me da algunos mensajes de error y no se como solucionarlo.
Alguien me podrá dar una manita?
Estos son los archivos log generados

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'CRO001ASO03' as 'ASADEM\GQUIROS' (trusted)
Starting maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:30:01 a.m.
[1] Database covibase: Updating Query Processor Statistics (sampling 10 percent of the data)...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.

** Execution Time: 0 hrs, 0 mins, 1 secs **

[2] Database covibase: Removing unused space from the database files (if database size is more than 50 MB). Reducing free space to 10 percent of data...
** Execution Time: 0 hrs, 0 mins, 1 secs **

End of maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:35:46 a.m.
SQLMAINT.EXE Process Exit Code: 1 (Failed)




________________

Geovanny Quirós C.
Heredia, Costa Rica

=_NextPart_000_0050_01C8F154.15EE3A20

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content=text/html;charset=iso-8859-1>
<META content="MSHTML 6.00.6000.16674" name=GENERATOR></HEAD>
<BODY id=MailContainerBody
style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"
bgColor=#ffffff leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Arial size=2>Hola grupo,</FONT></DIV>
<DIV><FONT face=Arial size=2>deseo implementar un plan de mantenimiento en
SQL2000, el asunto es que me da algunos mensajes de error y no se como
solucionarlo.</FONT></DIV>
<DIV><FONT face=Arial size=2>Alguien me podrá dar una manita?</FONT></DIV>
<DIV><FONT face=Arial size=2>Estos son los archivos log generados</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Microsoft (R) SQLMaint Utility (Unicode), Version
Logged on to SQL Server 'CRO001ASO03' as 'ASADEM\GQUIROS' (trusted)<BR>Starting
maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:30:01 a.m.<BR>[1]
Database covibase: Updating Query Processor Statistics (sampling 10 percent of
the data)...<BR>[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because
the following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
ARITHABORT'.<BR>[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because
the following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
ARITHABORT'.<BR>[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because
the following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
ARITHABORT'.<BR>[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because
the following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
ARITHABORT'.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp; ** Execution Time: 0 hrs, 0
mins, 1 secs **</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>[2] Database covibase: Removing unused space from
the database files (if database size is more than 50 MB). Reducing free space to
10 percent of data...<BR>&nbsp;&nbsp;&nbsp; ** Execution Time: 0 hrs, 0 mins, 1
secs **</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>End of maintenance plan 'Mantenimiento covibase' on
27/07/2008 10:35:46 a.m.<BR>SQLMAINT.EXE Process Exit Code: 1
(Failed)<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>&nbsp;</DIV></FONT><FONT face=Arial size=2>
<DIV><BR>&nbsp;<BR>________________</DIV>
<DIV>&nbsp;</DIV>
<DIV>Geovanny Quirós C.<BR>Heredia, Costa Rica<BR></FONT></DIV></BODY></HTML>

=_NextPart_000_0050_01C8F154.15EE3A20--
email Siga el debateRespuesta 11 respuestasRespuesta Tengo una respuesta

Preguntas similare

Mostrar todos los temas similares

Leer las respuestas

#1 Gustavo Larriera (MVP)
29/07/2008 - 17:01 | Informe spam
Por favor conéctese como usuario administrador. Ejecute esta consulta y
muéstrenos el resultado:

SELECT
database_name, activity, start_time, message
FROM
msdb..sysdbmaintplan_history
WHERE
error_number = 0

Gustavo Larriera, Microsoft MVP
http://www.linkedin.com/in/gustavolarriera
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.



"Geovanny Quirós C." wrote:

Hola grupo,
deseo implementar un plan de mantenimiento en SQL2000, el asunto es que me da algunos mensajes de error y no se como solucionarlo.
Alguien me podrá dar una manita?
Estos son los archivos log generados

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'CRO001ASO03' as 'ASADEM\GQUIROS' (trusted)
Starting maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:30:01 a.m.
[1] Database covibase: Updating Query Processor Statistics (sampling 10 percent of the data)...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.

** Execution Time: 0 hrs, 0 mins, 1 secs **

[2] Database covibase: Removing unused space from the database files (if database size is more than 50 MB). Reducing free space to 10 percent of data...
** Execution Time: 0 hrs, 0 mins, 1 secs **

End of maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:35:46 a.m.
SQLMAINT.EXE Process Exit Code: 1 (Failed)




________________

Geovanny Quirós C.
Heredia, Costa Rica

Respuesta Responder a este mensaje
#2 Geovanny Quirós C.
29/07/2008 - 17:43 | Informe spam
La consulta devuelve 0 rows

________________

Geovanny Quirós C.
Heredia, Costa Rica


"Gustavo Larriera (MVP)"
escribió en el mensaje de
noticias:
Por favor conéctese como usuario administrador. Ejecute esta consulta y
muéstrenos el resultado:

SELECT
database_name, activity, start_time, message
FROM
msdb..sysdbmaintplan_history
WHERE
error_number = 0

Gustavo Larriera, Microsoft MVP
http://www.linkedin.com/in/gustavolarriera
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.



"Geovanny Quirós C." wrote:

Hola grupo,
deseo implementar un plan de mantenimiento en SQL2000, el asunto es que
me da algunos mensajes de error y no se como solucionarlo.
Alguien me podrá dar una manita?
Estos son los archivos log generados

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'CRO001ASO03' as 'ASADEM\GQUIROS' (trusted)
Starting maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:30:01
a.m.
[1] Database covibase: Updating Query Processor Statistics (sampling 10
percent of the data)...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
ARITHABORT'.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
ARITHABORT'.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
ARITHABORT'.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
ARITHABORT'.

** Execution Time: 0 hrs, 0 mins, 1 secs **

[2] Database covibase: Removing unused space from the database files (if
database size is more than 50 MB). Reducing free space to 10 percent of
data...
** Execution Time: 0 hrs, 0 mins, 1 secs **

End of maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:35:46
a.m.
SQLMAINT.EXE Process Exit Code: 1 (Failed)




________________

Geovanny Quirós C.
Heredia, Costa Rica

Respuesta Responder a este mensaje
#3 Gustavo Larriera (MVP)
29/07/2008 - 17:50 | Informe spam
No hay historia de planes de mantenimiento :-(

Esperaba encontrar alli errores registrados de ejecuciones viejas de planes
de mantenimiento que sirvan para diagnosticar el problema.

Gustavo Larriera, Microsoft MVP
http://www.linkedin.com/in/gustavolarriera
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.



"Geovanny Quirós C." wrote:

La consulta devuelve 0 rows

________________

Geovanny Quirós C.
Heredia, Costa Rica


"Gustavo Larriera (MVP)"
escribió en el mensaje de
noticias:
> Por favor conéctese como usuario administrador. Ejecute esta consulta y
> muéstrenos el resultado:
>
> SELECT
> database_name, activity, start_time, message
> FROM
> msdb..sysdbmaintplan_history
> WHERE
> error_number = 0
>
> Gustavo Larriera, Microsoft MVP
> http://www.linkedin.com/in/gustavolarriera
> Este mensaje se proporciona tal como es, sin garantías de ninguna clase.
>
>
>
> "Geovanny Quirós C." wrote:
>
>> Hola grupo,
>> deseo implementar un plan de mantenimiento en SQL2000, el asunto es que
>> me da algunos mensajes de error y no se como solucionarlo.
>> Alguien me podrá dar una manita?
>> Estos son los archivos log generados
>>
>> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
>> 'CRO001ASO03' as 'ASADEM\GQUIROS' (trusted)
>> Starting maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:30:01
>> a.m.
>> [1] Database covibase: Updating Query Processor Statistics (sampling 10
>> percent of the data)...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>>
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>>
>> [2] Database covibase: Removing unused space from the database files (if
>> database size is more than 50 MB). Reducing free space to 10 percent of
>> data...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>>
>> End of maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:35:46
>> a.m.
>> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>>
>>
>>
>>
>> ________________
>>
>> Geovanny Quirós C.
>> Heredia, Costa Rica
>>

Respuesta Responder a este mensaje
#4 Gustavo Larriera (MVP)
29/07/2008 - 17:53 | Informe spam
Mis disculpas que le dije un filtro incorrecto en el WHERE (debí usar la
columna 'succeeded'). Por favor vuelva a ejecutar la consulta pero esta vez
sin WHERE:

SELECT
database_name, activity, start_time, message
FROM
msdb..sysdbmaintplan_history


Gustavo Larriera, Microsoft MVP
http://www.linkedin.com/in/gustavolarriera
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.



"Geovanny Quirós C." wrote:

La consulta devuelve 0 rows

________________

Geovanny Quirós C.
Heredia, Costa Rica


"Gustavo Larriera (MVP)"
escribió en el mensaje de
noticias:
> Por favor conéctese como usuario administrador. Ejecute esta consulta y
> muéstrenos el resultado:
>
> SELECT
> database_name, activity, start_time, message
> FROM
> msdb..sysdbmaintplan_history
> WHERE
> error_number = 0
>
> Gustavo Larriera, Microsoft MVP
> http://www.linkedin.com/in/gustavolarriera
> Este mensaje se proporciona tal como es, sin garantías de ninguna clase.
>
>
>
> "Geovanny Quirós C." wrote:
>
>> Hola grupo,
>> deseo implementar un plan de mantenimiento en SQL2000, el asunto es que
>> me da algunos mensajes de error y no se como solucionarlo.
>> Alguien me podrá dar una manita?
>> Estos son los archivos log generados
>>
>> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
>> 'CRO001ASO03' as 'ASADEM\GQUIROS' (trusted)
>> Starting maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:30:01
>> a.m.
>> [1] Database covibase: Updating Query Processor Statistics (sampling 10
>> percent of the data)...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>>
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>>
>> [2] Database covibase: Removing unused space from the database files (if
>> database size is more than 50 MB). Reducing free space to 10 percent of
>> data...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>>
>> End of maintenance plan 'Mantenimiento covibase' on 27/07/2008 10:35:46
>> a.m.
>> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>>
>>
>>
>>
>> ________________
>>
>> Geovanny Quirós C.
>> Heredia, Costa Rica
>>

Respuesta Responder a este mensaje
#5 Geovanny Quirós C.
29/07/2008 - 17:59 | Informe spam
Si es que cada vez que he intentado implementarlo me da errores :(


________________

Geovanny Quirós C.
Heredia, Costa Rica


"Gustavo Larriera (MVP)"
escribió en el mensaje de
noticias:
No hay historia de planes de mantenimiento :-(

Esperaba encontrar alli errores registrados de ejecuciones viejas de
planes
de mantenimiento que sirvan para diagnosticar el problema.

Gustavo Larriera, Microsoft MVP
http://www.linkedin.com/in/gustavolarriera
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.



"Geovanny Quirós C." wrote:

La consulta devuelve 0 rows

________________

Geovanny Quirós C.
Heredia, Costa Rica


"Gustavo Larriera (MVP)"
escribió en el mensaje de
noticias:
> Por favor conéctese como usuario administrador. Ejecute esta consulta y
> muéstrenos el resultado:
>
> SELECT
> database_name, activity, start_time, message
> FROM
> msdb..sysdbmaintplan_history
> WHERE
> error_number = 0
>
> Gustavo Larriera, Microsoft MVP
> http://www.linkedin.com/in/gustavolarriera
> Este mensaje se proporciona tal como es, sin garantías de ninguna
> clase.
>
>
>
> "Geovanny Quirós C." wrote:
>
>> Hola grupo,
>> deseo implementar un plan de mantenimiento en SQL2000, el asunto es
>> que
>> me da algunos mensajes de error y no se como solucionarlo.
>> Alguien me podrá dar una manita?
>> Estos son los archivos log generados
>>
>> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
>> Server
>> 'CRO001ASO03' as 'ASADEM\GQUIROS' (trusted)
>> Starting maintenance plan 'Mantenimiento covibase' on 27/07/2008
>> 10:30:01
>> a.m.
>> [1] Database covibase: Updating Query Processor Statistics (sampling
>> 10
>> percent of the data)...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
>> [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
>> [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
>> [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
>> [Microsoft][ODBC
>> SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the
>> following SET options have incorrect settings: 'QUOTED_IDENTIFIER,
>> ARITHABORT'.
>>
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>>
>> [2] Database covibase: Removing unused space from the database files
>> (if
>> database size is more than 50 MB). Reducing free space to 10 percent
>> of
>> data...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>>
>> End of maintenance plan 'Mantenimiento covibase' on 27/07/2008
>> 10:35:46
>> a.m.
>> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>>
>>
>>
>>
>> ________________
>>
>> Geovanny Quirós C.
>> Heredia, Costa Rica
>>

Respuesta Responder a este mensaje
Ads by Google
Help Hacer una preguntaSiguiente Respuesta Tengo una respuesta
Search Busqueda sugerida