Diminuir tamanho de log do banco SHRINK
Para reduzir o tamanho do arquivo de log do banco, quando aparece a msg “The transaction log for database ‘PayReport’ is full due to ‘LOG_BACKUP'”
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
USE PayReport; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE PayReport SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (PayReport_Log, 1); GO -- Reset the database recovery model. ALTER DATABASE PayReport SET RECOVERY FULL; GO |