Community
Showing results for 
Search instead for 
Do you mean 
Reply

How Can I Shrink or Truncate SQL Server Log?

New Member
Posts: 1
Country: United States

How Can I Shrink or Truncate SQL Server Log?

I appreciate any assistance towards shrinking or truncating SQL Server Log.  The only version of SQL Server that is on my machine services the ACT! database.  All of the MS instructions for shrinking or truncating SQL Server Log in SQL Server 2005 assumes that I have the full MS SQL Server package.  I can get to the Log file, but do not wish to just delete the files.  I have 39G that is taking up a good bit of space on my hard drive.  Any help is appreciated.
Moderator
Posts: 4,395
Country: USA

Re: How Can I Shrink or Truncate SQL Server Log?

Which log file(s) are you referring to?  If they are the ones in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG, then you can delete them.