auto shrink,

  • Msg 1105, Level 17, State 2, Line 1

    Could not allocate space for object 'dbo.Pre_Dispatch_Exception_SummaryDD2_tbl' in database 'DRCVolumeMetric' because the 'TERTIARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

  • Is there a question here?

    If you're looking for a resolution, there's one in the error message

    Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup

    Oh, and if autoshrink is on, turn it off!

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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