SQLTeam.com | Weblogs | Forums

Chunk Table in ReportServer Database


#1

Hi,

this table is grow up to 30G, why?
Can i empty it?

thanks


#2

Yes its possible. you can truncat the below tables

TRUNCATE TABLE Segment
TRUNCATE TABLE SegmentedChunk
TRUNCATE TABLE SessionData
TRUNCATE TABLE SnapshotData
TRUNCATE TABLE ChunkData
TRUNCATE TABLE ChunkSegmentMapping

and shrunk the db and log files