May 8, 2006 at 3:12 pm
My transaction Log space is 32GB used. my total disk space 10MB. so how i can reclaim 32GB, as i cannot do any backup. CHECKPOINT is not helping me. i tried DBCC Shrinkfile (Database,100)& it didn't help either. can any one suggest or help me to resolve this issue.
May 8, 2006 at 3:41 pm
Are there any open transactions on the base, use
dbcc opentran
If there are these might be bloating the log, if so you may need to kill the spid, be aware that it may well rollback which may cause you issues.
May 8, 2006 at 3:55 pm
Another option you might not like (and should use only after careful consideration) is to backup the log using the TRUNCATE_ONLY option. It will remove the inactive part of the log without backing it up. This means you will lose any log data for that period of time. It should then allow you to shrink the file and reclaim some space. I'd recommend doing a full backup at the next available opportunity if you do this, however.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply