[dba-SQLServer] Take Database Offline and Delete - How aboutmsllockdb?

Hi Julie:

You have to use the DBCC SHRINKFILE command to shrink the physical size of a 
transaction log.  But before shrinking the tlog file, you have truncate 
parts of the tlog via the BACKUP LOG command.

Please refer to BOL for more information (under topic "shrinking transaction 
logs")

HTH
Billy

>From: "Julie Reardon-Taylor" <prosoft6 at hotmail.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer] Take Database Offline and Delete - How 
>aboutmsllockdb?
>Date: Mon, 04 Apr 2005 12:00:09 -0400
>
>My transaction log for my msllockdb file is growning too.  I know that 
>backing up the transaction log is supposed to shrink this log file, but it 
>doesn't seem to be working.  Can you recommend a way to shrink this file?  
>What are the correct steps?  Back up the trans log, then backup the 
>database?  I shouldn't have to detach and then shrink and re-attach should 
>I?
>
>
>
>Julie Reardon-Taylor
>PRO-SOFT OF NY, INC.
>44 Public Square Suite #5
>Watertown, NY 13601
>(315) 785-0319
>www.pro-soft.net
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>