34 lines
573 B
Markdown
34 lines
573 B
Markdown
---
|
||
tags:
|
||
- upnote-import
|
||
---
|
||
|
||
# SQL-Transaktionslog verkleinern
|
||
|
||
## Auflistung aller DB-Files
|
||
|
||
```
|
||
SELECT
|
||
DB_NAME(database_id) AS DatabaseName,
|
||
name AS LogicalName,
|
||
physical_name AS PhysicalPath,
|
||
type_desc AS FileType,
|
||
size * 8 / 1024 AS SizeMB,
|
||
growth AS GrowthSetting,
|
||
is_percent_growth AS IsPercentGrowth
|
||
FROM sys.master_files
|
||
ORDER BY database_id, type;
|
||
```
|
||
|
||
Recovery-Mode auf SIMPLE einstellen
|
||
|
||
```
|
||
ALTER DATABASE krah_dwext SET RECOVERY SIMPLE
|
||
```
|
||
|
||
DB-File verkleinern, hier 100 MB
|
||
|
||
```
|
||
DBCC SHRINKFILE (##LogicalName##, 102400)
|
||
```
|