var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a Database of size 200 MB and my transactio log is 13GB(very high).So can I truncate the log file by taking a fresh full backup?
What's your Recovery model?
When was the last time you did a backup?
And change the auto grow feature and disable it....
It's a Great Day for America everybody!
dbforums Yak CorralRadio 'Rita
dbForums Member List
I'm Good Once as I ever was
The physical order of data in a database has no meaning.
You need to do a full backup, and then do a log backup right after that. Then you can shrink the log.
if you're going to truncate the log, you can just set the recovery model to SIMPLE, then you won't run into this issue again. Only reason you need the FULL recovery model is if you're taking transaction log backups at intervals thru out the day.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors