Удаление MuLog: как обрезать логи MU online до 1 MB

[Wikko0]

Your MuLog file (DB LDF File) has become 1 - 2 or even 3 GB, u don't need it and it's only bumping space on your hard drive... Or may be your HDD is set to FAT32 and 1 file can't be more than 4GB and u can't run the server! Then do this and it will become 1 MB:

1. Open SQL Query Analyzer
Start > All Programs > Microsoft SQL Server > Query Analyzer
2. Type your SQL password
3. Copy - Paste this query in the blank field:

USE master
backup log [MuOnline] with truncate_only
dbcc shrinkdatabase([MuOnline],0)

4. Press F5 (Execute the query)

Now the "muonline_Log.LDF" is only 1024 KB and it will not grow...
Enjoy!

By DarksTeam