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