Oct
26
2009
26
2009
SQL Log Files Too Large?
Posted by frostie-user
Comments Off on SQL Log Files Too Large?
Are you SQL log files getting too large?
Is your SQL server running out of disk space?
Look at you log files, as databases with FULL RECOVERY mode selected can grow out of control…
Use this in Query Analyser
BACKUP LOG DATEBASE
WITH TRUNCATE_ONLY
Then shrink the log file in Enterprise Manger / SQL Server Management Studio
Disclaimer: I do not guarantee that this will solve your problem and any tips listed on this website you use at your own risk
Tag Cloud
2008 Ford Mondeo Titanium X
alphacourse
bertweedon
BHF
bible
bike ride
Billy Graham
christmas eve
explosion
Gary Moore
guitartuner
Ignite the flame
Jesus
London to Southend
mic cables
Nissan Qashqai+2 Tekna Red
onsong
pa
parentingcourse
pedalboard
playinaday
qashqai
Rock Thurrock
senseatlast
snowday
squirrel
sundaysetlist
tftd
twentysevenmillion
updated
vbs
WhitneyHouston
windows
worship
worshipleading
Worship Leading
worshipset
wscript
XenAPP