Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1374

Re: Help with shrinking a database

Show all headers | View raw

On Jan 10, 8:15 am, Dom <dolivas...@gmail.com> 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.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Help with shrinking a database Dom <dolivastro@gmail.com> - 2013-01-10 05:15 -0800
  Re: Help with shrinking a database Dom <dolivastro@gmail.com> - 2013-01-10 05:24 -0800
  Re: Help with shrinking a database Erland Sommarskog <esquel@sommarskog.se> - 2013-01-10 20:58 +0100
    Re: Help with shrinking a database Query Builder <querybuilder@gmail.com> - 2013-01-10 13:54 -0800
      Re: Help with shrinking a database Erland Sommarskog <esquel@sommarskog.se> - 2013-01-10 23:20 +0100
        Re: Help with shrinking a database Dom <dolivastro@gmail.com> - 2013-01-11 05:03 -0800
          Re: Help with shrinking a database Erland Sommarskog <esquel@sommarskog.se> - 2013-01-11 14:39 +0100
        Re: Help with shrinking a database Query Builder <querybuilder@gmail.com> - 2013-01-11 13:46 -0800
          Re: Help with shrinking a database Erland Sommarskog <esquel@sommarskog.se> - 2013-01-11 23:28 +0100

csiph-web