Printable View
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.
is what I'm usingQuote:
USE master
backup log [MuOnline] with truncate_only
dbcc shrinkdatabase([MuOnline],0)
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.
MuOnline db>Properties>Options>Recovery model change from "full" to "simple"Quote:
Originally Posted by MHUii
now db shrinks with time!
Runing this in QA MuOnline db changed to 200mb from 19GB :d
dbcc shrinkfile (MuOnline_log, 20000, TRUNCATEONLY)
Thanks for help - neo6 and for info Abols
easy wayQuote:
Originally Posted by MHUii
http://4rapiddev.com/sql-server/dele...-log-ldf-file/
Thankyou so much!Quote:
Originally Posted by piradzins
very usefull tnx a lot xD