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

Julie Reardon-Taylor prosoft6 at hotmail.com
Mon Apr 4 11:00:09 CDT 2005


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





More information about the dba-SQLServer mailing list