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,808 of 19,505   
   Dom to Dom   
   Re: Help with shrinking a database   
   10 Jan 13 05:24:49   
   
   430ecb75   
   8fd294a8   
   From: dolivastro@gmail.com   
      
   On Jan 10, 8:15 am, Dom  wrote:   
   > 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?   
      
   When I look at the activity monitor, I find that the process is   
   executing DbccFilesCompact, and the status is now suspended.  If I   
   look at the "locks by object" I find that the process ID has several   
   locks, almost all of the Page type.   
      
   --- 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