Truncate Transaction Log

Last Post 03 Aug 2009 12:18 AM by hussam1977. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sql-tips
New Member
New Member

--
22 May 2009 11:31 AM
I can't truncate the transaction log, it has 50GB even after truncate command still show same. Here is what I did.

1. Made the database to simple.
2. DBCC SHRINKFILE(db_Log, 5)
BACKUP LOG db_name WITH TRUNCATE_ONLY
DBCC SHRINKFILE(db_Log,5)
3. I took full backup of the database and tried still didn't reduce the size.

what could be the reason.
hussam1977
New Member
New Member

--
03 Aug 2009 12:18 AM
to reduce the size of tranaction logs file:
first of all, change the recovery model to simple.
second, take a backup.
then, shrink only the log file.
at the end see the size of log database how much reduced.
You are not authorized to post a reply.

Acceptable Use Policy