sql server - DBCC SHRINKFILE failing -


i'm trying shrink database on test system file won't smaller. size of mdf file 47 gb , unused space 38 gb. lot of data removed database hence large amount of unused space.

the following error appears: start dbcc shrinkfile ( olympus_dat, 46912 ) @ 2015-07-23 15:27:19.300 dbcc shrinkfile: page 1:6017543 not moved because has not been formatted.

how can fix error?

sql server 2012 x64

additional information. following queries return error:

dbcc traceon(3604) go  dbcc page('olympus', 1, 6017543, 1) go  dbcc traceoff(3604) go 

dbcc execution completed. if dbcc printed error messages, contact system administrator.

page: (14440:908631589)

buffer:

buf @0x0000000009682040

bpage = 0x00000002b46b8000 bhash = 0x0000000000000000 bpageno = (1:6017543) bdbid = 6 breferences = 1 bcputicks = 0 bsamplecount = 0 buse1 = 23548 bstat = 0x809 blog = 0x5adb215a bnext = 0x0000000000000000

page header:

page @0x00000002b46b8000

m_pageid = (14440:908631589) m_headerversion = 252 m_type = 226 m_typeflagbits = 0xf9 m_level = 216 m_flagbits = 0xd676 m_objid (allocunitid.idobj) = -1238914908 m_indexid (allocunitid.idind) = 23941 metadata: allocunitid = 6738992698879115264 metadata: partitionid = 0 metadata: indexid = -1 metadata: objectid = 0 m_prevpage = (35510:854211095) m_nextpage = (61606:1041616947) pminlen = 43990 m_slotcnt = 27900 m_freecnt = 40464 m_freedata = 34288 m_reservedcnt = 12643 m_lsn = (-257029635:1920476993:30788) m_xactreserved = 11969 m_xdesid = (25449:1820050307) m_ghostreccnt = 61532 m_tornbits = -213551362 db frag id = 1

allocation status

gam (1:5623552) = allocated sgam (1:5623553) = allocated
pfs (1:6017472) = 0x40 allocated 0_pct_full diff (1:5623558) = not changed ml (1:5623559) = not min_logged

compressioninfo @0x00000000309682b0

compressioninfo raw bytes

compressioninfo size (in bytes) = 0 pagemodcount = 50289 ci header flags =

data:

slot 0, offset 0x4ad2, length 1, dumpstyle byte

record type = (compressed) empty_ghost_record record size = 1

cd array

record memory dump

000000003096ead2: 05 .
msg 0, level 11, state 0, line 0 severe error occurred on current command. results, if any, should discarded.

please follow steps given in answer @ bottom of page,

https://ask.sqlservercentral.com/questions/19676/dbcc-shrinkfile-error.html


Comments

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

Nuget pack csproj using nuspec -