Shrink Database

Tối ưu dọn dẹp database trên MS SQL SERVER

KIỂM TRA RECOVERY MODE DATABASE

SELECT name, recovery_model_desc
FROM sys.databases
WHERE name = 'DTECH_HN';
GO

CHUYỂN ĐỔI RECOVERY MODE DATABASE

--- KHÔNG LƯU LOG
USE [master];
GO
ALTER DATABASE [DTECH_HN]
SET RECOVERY SIMPLE;
GO

--- LƯU TẤT CẢ LOG
USE [master];
GO
ALTER DATABASE [DTECH_HN]
SET RECOVERY FULL;
GO

SHRINK A DATABASE

DBCC SHRINKDATABASE (DTECH_HN, 10);
GO

Tham khảo:

https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-ver16