Audit partition anomaly

(0) Share

Report

Posted on by G.Vetere

Hi,

I've noticed there is a rogue partition that can only be viewed from SQL. Anyone have any ideas how to remove it safely?

0268.crm-audit.PNG

I've used the following query to view it within SQL

IF (CONVERT(int, (SELECT SERVERPROPERTY('EngineEdition'))) = 3) 
        BEGIN 
                SELECT  partition_number AS 'PartitionNumber' 
                                , prv.value AS 'End Date' 
                                , used_page_count*8 AS 'Size in KB' 
                FROM sys.dm_db_partition_stats pst LEFT OUTER JOIN sys.partition_range_values prv ON prv.boundary_id = pst.partition_number 
                WHERE object_id = object_id('AuditBase') 
                AND index_id in (0,1) 
        END 
ELSE 
        BEGIN 
                SELECT  DATENAME(qq, CreatedOn) AS 'Quarter' 
                                , YEAR(CreatedOn) AS 'Year' 
                                , COUNT(*) AS 'Rows' 
                FROM AuditBase 
                GROUP BY DATENAME(qq, CreatedOn), YEAR(CreatedOn) 
                ORDER BY 'Year','Quarter' 
        END

*This post is locked for comments

All responses (2)

Answers (0)

G.Vetere 2 on at

Like (0)

Report

RE: Audit partition anomaly

No, you cannot delete the last partition log, there has to be at least one
Clem 2,541 on at

Like (0)

Report

RE: Audit partition anomaly

What about the delete button ?

You can only delete the oldest log anyway :-)

Clément