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
Post a Comment