Truncating / Shrinking Logs and DB's
From: Timmeah (timoth_at_optushome.com.au)
Date: 01/06/05
- Next message: Olu Adedeji: "RE: Visual Basic ActiveX Script question"
- Previous message: Olu Adedeji: "Re: Trace of Memory Usage ?"
- Next in thread: Peter The Spate: "Truncating / Shrinking Logs and DB's"
- Reply: Peter The Spate: "Truncating / Shrinking Logs and DB's"
- Reply: ag: "Re: Truncating / Shrinking Logs and DB's"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 6 Jan 2005 21:08:08 +1100
Ok i am trying to get my skills down with SQL server and am stumped with the
size of my log files.
I have read to:
backup your transaction log
backup your DB
truncate the logfile, sp_dboption [dbname], 'trunc. log on chkpt.', 'true'
shrink the log file, dbcc shrinkfile ([db_log_name])
seems straight forward enough.
Ok i have tried this a few times on different db's and it hasn't done
anything to the file size.
I have noticed sometimes the log size actually increases usage with no
physical size drop.
Am i not doing something right or overlooking something?
Please help.
Tim
'F@#$ing windows 98! Get Bill Gates in here! You told us Windows 98 would be
faster, and more efficient, with better access to the internet!'
'It is faster, over five million' (Gunshot)
- Next message: Olu Adedeji: "RE: Visual Basic ActiveX Script question"
- Previous message: Olu Adedeji: "Re: Trace of Memory Usage ?"
- Next in thread: Peter The Spate: "Truncating / Shrinking Logs and DB's"
- Reply: Peter The Spate: "Truncating / Shrinking Logs and DB's"
- Reply: ag: "Re: Truncating / Shrinking Logs and DB's"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
