BANCO DE DADOS

26 de Julho de 2018 / Last updated : 26 de Julho de 2018 victorgarcia_wp BANCO DE DADOS

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'”

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

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

Categorias: BANCO DE DADOS e MSSQL SERVER

VictorGarcia.com.br

Diminuir tamanho de log do banco SHRINK

Deixar uma resposta Cancelar resposta