brain/04 Ressourcen/IT/SQL-Transaktionslog verkleinern.md

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)