[Guide] Delete / Truncate MuLog

ReaL

New Member

Joined

Apr 13, 2008

Messages

1,244

Reaction score

656

• Apr 14, 2008

• #1

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:

Code:

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! :bigsmile:

By DarksTeam

 

• 

Reactions: Dea7h, hrisiz, nmilchev and 13 others

ProHouse

New Member

Joined

Apr 28, 2008

Messages

57

Reaction score

0

• Apr 29, 2008

• #2

Добре де ама на мене папката ExDB ми става все по голяма а не този файл как мога нея да оправи???

 

Mephisto

New Member

Joined

Apr 10, 2008

Messages

451

Reaction score

240

• Apr 29, 2008

• #3

В muserver/ всичко завършващо на .log му вкарваш по едно Delete

 

ReaL

New Member

Joined

Apr 13, 2008

Messages

1,244

Reaction score

656

• Apr 30, 2008

• #4

Mephisto said:

В muserver/ всичко завършващо на .log му вкарваш по едно Delete

Click to expand...

дам

Правиш .bat file:

Code:

del D:\MuServer\*.log /q /s

 

Last edited: Oct 24, 2008

• 

Reactions: darkkingh, MapTuH4y, NakazaTeLq and 1 other person

Break House

Active Member

Joined

Apr 26, 2008

Messages

281

Reaction score

34

• Oct 24, 2008

• #5

Благодаря ти !!!

 

RhysFox

New Member

Joined

Jun 30, 2008

Messages

918

Reaction score

299

• Oct 25, 2008

• #6

Чудесно. 10/10

 

FreestyleR

New Member

Joined

May 14, 2008

Messages

129

Reaction score

19

• Oct 25, 2008

• #7

Надявам се и това да ви свърши работа, за триене на логове бат файл ... ::

 

Attachments

• delete_all_logs.rar

  245 bytes · Views: 47

Gasolincho

Well-Known Member

Joined

May 15, 2008

Messages

683

Reaction score

693

• Dec 19, 2008

• #8

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

99b+, and log still big...

 

• 

Reactions: enduwe

ReaL

New Member

Joined

Apr 13, 2008

Messages

1,244

Reaction score

656

• Dec 19, 2008

• #9

Ако DBCC командите извеждат грешки, липсва driver на MsSQL-a (или има нерегистрирано dll при MDAC driver-ите)

 

O

OmaRuCat

Well-Known Member

Joined

Jun 3, 2008

Messages

531

Reaction score

457

• Jan 24, 2009

• #10

незнам за ва но аз това го пуснах и дб-то стана 1 мб след това пак почна става голямо 50 мб ми е вече :s:s:s

 

ReaL

New Member

Joined

Apr 13, 2008

Messages

1,244

Reaction score

656

• Jan 25, 2009

• #11

Пускайте си го периодично или най-добре си го драснете като SQL Agent Job на определено време (не прави мн лаг, стига да е през по-голямо време, например 2 дена) :}

 

B

banned

Active Member

Joined

Jan 4, 2009

Messages

616

Reaction score

71

• Dec 17, 2009

• #12

FreestyleR said:

Надявам се и това да ви свърши работа, за триене на логове бат файл ... ::

Click to expand...

това без да искам го стартирах от дескопа и почти всичко ми се истри имали начин да ги вастановя ?

 

Babaka

New Member

Joined

Feb 8, 2009

Messages

153

Reaction score

4

• May 30, 2010

• #13

Въпрос: Как може да се изключи този лог?

 

ultimater

Member

Joined

Feb 18, 2010

Messages

51

Reaction score

4

• Feb 7, 2011

• #14

И аз искам да попитам същото... Как се спират логовете ??

 

Mario1

New Member

Joined

Jul 25, 2010

Messages

285

Reaction score

37

• Feb 7, 2011

• #15

никак.

 

hrisiz

Active Member

Joined

Feb 3, 2010

Messages

429

Reaction score

81

• Jun 30, 2013

• #16

Msg 155, Level 15, State 1, Line 2
'truncate_only' is not a recognized BACKUP option.
? някой да знае как да го оправя ? ползвам MSSQL 2012

 

Last edited: Jul 5, 2013