Calendar
April 2010
M D M D F S S
« Dez   Nov »
 1234
567891011
12131415161718
19202122232425
2627282930  

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