Very Computer

dbcc shrinkfile (file)

does nothing.  It just says DBCC execution completed immediately.  It
normally works fine for me.  I've run it hundreds of times before.

sp_spaceused reports that the file is only 20GB big and not 40GB!  I've run
dbcc updateusage, but to no avail.  And this is a data file, not a log file.
I'm currently running dbcc checkdb on the database, but am reluctant to use
it to fix any errors (assuming it finds any), because I don't want to take
the database offline or single-user.  It's OLTP and about 200GB.

Can anyone help with this?

TIA,

Joseph.

Data moved to remaining space.   Space calculated to db size + the %free.

Quote:> I've got a data file which is 40GB, but is half empty.  I want to shrink
it,
> but the shrink doesn't work:

> dbcc shrinkfile (file)

> does nothing.  It just says DBCC execution completed immediately.  It
> normally works fine for me.  I've run it hundreds of times before.

> sp_spaceused reports that the file is only 20GB big and not 40GB!  I've
run
> dbcc updateusage, but to no avail.  And this is a data file, not a log
file.
> I'm currently running dbcc checkdb on the database, but am reluctant to
use
> it to fix any errors (assuming it finds any), because I don't want to take
> the database offline or single-user.  It's OLTP and about 200GB.

> Can anyone help with this?

> TIA,

> Joseph.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.

Quote:> I've got a data file which is 40GB, but is half empty.  I want to shrink it,
> but the shrink doesn't work:

> dbcc shrinkfile (file)

> does nothing.  It just says DBCC execution completed immediately.  It
> normally works fine for me.  I've run it hundreds of times before.

> sp_spaceused reports that the file is only 20GB big and not 40GB!  I've run
> dbcc updateusage, but to no avail.  And this is a data file, not a log file.
> I'm currently running dbcc checkdb on the database, but am reluctant to use
> it to fix any errors (assuming it finds any), because I don't want to take
> the database offline or single-user.  It's OLTP and about 200GB.

> Can anyone help with this?

> TIA,

> Joseph.

(1) I do not want to shrink the whole database, just one file.  The whole database is >200GB and it's only one file that needs shrinking.  dbcc shrinkfile is the correct command.  I've done this dozens of times and it's always worked before.

(2) The file was originally created with a size of only 5GB, so it should shrink to 20GB.

(3) I am not specifying a target size because I want to shrink it as far as it'll go.

Any more ideas would be much appreciated.

Thanks,

Joseph

Quote:> I've got a data file which is 40GB, but is half empty. I want to shrink
it,
> but the shrink doesn't work:

> dbcc shrinkfile (file)

> does nothing. It just says DBCC execution completed immediately. It
> normally works fine for me. I've run it hundreds of times before.

> sp_spaceused reports that the file is only 20GB big and not 40GB! I've
run
> dbcc updateusage, but to no avail. And this is a data file, not a log
file.
> I'm currently running dbcc checkdb on the database, but am reluctant to
use
> it to fix any errors (assuming it finds any), because I don't want to take
> the database offline or single-user. It's OLTP and about 200GB.

> Can anyone help with this?

> TIA,

> Joseph.