salve,
On 06/05/2012 12:45, glopie wrote:

Ciao!
avendo un db in modalità full e considerando che il file di log risulta in uso , si puo' verificare che l'operazione di shrink del db non si cpmpleti regolarmente ?
grz
alb63

cosa intendi con "non si completi regolarmente"? a tutti gli effetti si completa, ma ...
(dai BOL) "... DBCC SHRINKDATABASE tries to shrink each physical log file to its target size immediately. If no part of the logical log resides in the virtual logs beyond the target size of the log file, the file is successfully truncated and DBCC SHRINKDATABASE finishes without any messages. However, if part of the logical log resides in the virtual logs beyond the target size, the Database Engine frees as much space as possible, and then issues an informational message. The message describes what actions are required to move the logical log out of the virtual logs at the end of the file. After the actions are performed, DBCC SHRINKDATABASE can be used to free the remaining space. For more information, see Shrinking the Transaction Log. ..."
saluti
.