home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 17,644 of 19,505   
   m to All   
   Shrinking database, simple model   
   24 Sep 09 10:25:33   
   
   From: miroslavsi@gmail.com   
      
   Hello,   
      
   We have database in SIMPLE recovery model.   
      
   MDF file is about 3GB   
   but LDF file is about 15GB   
      
   We tried to shrink LDF, and after shrinking we got LDF about 7GB.   
      
   We used shrinking before and LDF file was always about 1Mb.   
      
   Can anyone tell me why SQL server still keep that 7 GB in LDF file and is   
   there any chance for server to release that space on his own without forsing   
   it?   
   Is that just a question of time, and becouse SIMPLE recovery model SQL   
   server will do it by itself?   
      
   Thanks in advance,   
      
   Regards   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca