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

Help with shrinking a database

Newsgroups	comp.databases.ms-sqlserver
Date	2013-01-10 05:15 -0800
Message-ID	<6918100a-d4c7-4714-8f16-20e7334ff1ab@d4g2000vbw.googlegroups.com> (permalink)
Subject	Help with shrinking a database
From	Dom <dolivastro@gmail.com>

Show all headers | View raw

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?

Back to comp.databases.ms-sqlserver | Previous | Next — 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