How to fix 10 GB database to 2mb

i know that many have problem with Muonline_log.ldf
as it grows bigger after 1days i hope this will help u
Go to Start > All Programs > Sql Server > Sql Query Analyzer



type in this:

use muonline
backup log MuOnline with NO_LOG
backup log MuOnline with TRUNCATE_ONLY
DBCC SHRINKDATABASE(MuOnline)

after this u press F5 or parse it

You sure this works?
I will do a database backup before doing this, maybe it ruins up the database.

yes it works 100%, with no problems. It' deletes the log files wich are useless. Only muonline_data is important

It works but he isn't talking about the database size... he is talking about transaction logs.

Quote:

---

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

---

is what I'm using

OR, you can download this program: Here

Very nice ;)

Nice and its work, my 50gb now is 2mb :)

limited size ... if log full on limited , you can't make any items on editor or can't add Credits in SavoyWebshop..... bcuz log is full... i think normal is best

sry for my bad eg.

Great! 10/10

tnx men 10/10 !

whoa, thx

Thanks! It is very good.

not works for me, i use 97d based database, also made backup for Rankigs, but as i had 100MB total, that still i have...

thank's ! my DB is 34 GH now is 1mb

i have 97d 7 gb = 100 mb tnx for script ^_^

Help me i used this code on sql server 2008 r2
it say's

Quote:

---

msg 155, level 15, state 1, line 3'truncate_only' is not a recognized backup option.

---