Group: microsoft.public.sqlserver.server · Group Profile
Author: Linchi SheaLinchi Shea Date: Jun 16, 2008 13:08
Also, do a DBCC OPENTRAN inside that database to see if there is any
long-running open tran preventing you from reclaiming the log space.
Linchi
"R C" wrote:
> hi,
> i have a database that has a datafile of 40+GB and a log file of 51GB. i
> don't need the log file. i tried to do a shrinkfile command and it doesn't
> seem to make the file smaller. the command i'm running is:
> dbcc shrinkfile ('MA_Log', 1000, TRUNCATEONLY)
>
> please advise how to do this.
>
> thanks,
| 
