> For the complete documentation index, see [llms.txt](https://kythuat.dtechvn.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kythuat.dtechvn.com/sql-server/shrink-database.md).

# Shrink Database

## KIỂM TRA RECOVERY MODE DATABASE

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

## CHUYỂN ĐỔI RECOVERY MODE DATABASE

```sql
--- 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

```sql
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>