Ciao,
ho pianificato la manutenzione di alcuni database presenti su un server nel seguente modo :
backup full - all user database ore 20.00
clean ore 13.15
shrink ore 05.00 e ore 13.30
Tutti i processi vengono eseguiti giornalmente.
Inizialmente tutto andava a buon fine, ma da un po' di tempo a questa parte l'operazione di shrink mi va costantemente in errore e il file di log è il seguente :
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042 Report was generated on "TOBluDB".
Maintenance Plan: Shrink_1
Duration: 00:01:52
Status: Warning: One or more tasks failed..
Details:
Shrink Database Task (TOBluDB)
Shrink Database on Local server connection Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
Databases: All user databases
Limit: 50 MB
Free space: 10 %
Task start: 2010-12-27T05:00:12.
Task end: 2010-12-27T05:00:47.
Failed:(-1073548784) Executing the query "DBCC SHRINKDATABASE(N'TO_DATI', 10, TRUNCATEONLY) " failed with the following error: "A severe error occurred on the current command. The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [TO_DATI]
GO
DBCC SHRINKDATABASE(N''TO_DATI'', 10, TRUNCATEONLY) GO USE [BLUSERVIZI] GO DBCC SHRINKDATABASE(N''BLUSERVIZI'', 10, TRUNCATEONLY) GO USE [TO_CONT_NET] GO DBCC SHRINKDATABASE(N''TO_CONT_NET'', 10, TRUNCATEONLY) GO USE [DW_AppoggioEE] GO DBCC SHRINKDATABASE(N''DW_AppoggioEE'', 10, TRUNCATEONLY) GO USE [DW_AppoggioGAS] GO DBCC SHRINKDATABASE(N''DW_AppoggioGAS'', 10, TRUNCATEONLY) GO USE [TO_DATI_M] GO DBCC SHRINKDATABASE(N''TO_DATI_M'', 10, TRUNCATEONLY) GO USE [TO_DUALGAS_DATI] GO DBCC SHRINKDATABASE(N''TO_DUALGAS_DATI'', 10, TRUNCATEONLY) GO USE [BLUDW] GO DBCC SHRINKDATABASE(N''BLUDW'', 10, TRUNCATEONLY) GO USE [BLUDW_NEW] GO DBCC SHRINKDATABASE(N''BLUDW_NEW'', 10, TRUNCATEONLY)
ho provato eliminando il processo di Shrink e inserendone uno nuovo ma il problema resta.
Comne posso risolverlo?