Post reply

mdf_MSSQL_DBCC8, .ndf_MSSQL_DBCC8 extension files

  • July 17, 2017 at 8:13 am

    #327511

    Hello,

    Can see few files against one database with extension as (mdf_MSSQL_DBCC8, .ndf_MSSQL_DBCC8 extension files). Are these database sparse files generated part of dbcc command? But currently there is no such job running and it is still residing and consuming a lot of space.

    Any suggestion how to remove them?

    Thanks.

  • July 17, 2017 at 8:25 am

    #1951166

    SQL-DBA-01 - Monday, July 17, 2017 8:13 AM

    Hello,

    Can see few files against one database with extension as (mdf_MSSQL_DBCC8, .ndf_MSSQL_DBCC8 extension files). Are these database sparse files generated part of dbcc command? But currently there is no such job running and it is still residing and consuming a lot of space.

    Any suggestion how to remove them?

    dbccc8 is appended to the files for the internal snapshot generated for dbcc checkdb.
    I've only seen them not delete once and it was a non-prod environment - the dbcc had an error and the files could not be deleted as they were seen as in use by SQL Server. Not production so a restart was okay and cleaned them up.

    Sue

  • July 18, 2017 at 7:13 am

    #1951389

    Thank you. After recycle the files gone

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply