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
DRAGON AGE™: INQUISITION – Matadragones
 

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

Preguntas similares

 

Busqueda sugerida :