SQL-Server Logfiles kürzen / Shrink SQL-Server DB Logfiles

USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO

should work everytime :)

Antwort schreiben