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 18,807 of 19,505   
   Dom to All   
   Help with shrinking a database   
   10 Jan 13 05:15:05   
   
   8fd294a8   
   From: dolivastro@gmail.com   
      
   I have a database that is usually shrunk every month.  This takes   
   anywhere from 15 minutes to 1 hour.  But this time, it has been   
   running over 24 hours and I see no evidence (looking at the file   
   sizes, and the free space on the disk, in windows explorer) that it is   
   being shrunk at all, and the log file keeps increasing -- it went from   
   60M to 659M.   
      
   The disk that it sits on has plenty of free space.  No one is using   
   the database.   
      
   I don't want to kill it, because I think I might lose data.  How do I   
   get out of this?   
      
   --- 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