Data Center Security

 View Only
Back to discussions
Expand all | Collapse all

SQL DB Data drive is full and getting filled with SCSPDB_analysis_eventDailyFG1.ndf files

  • 1.  SQL DB Data drive is full and getting filled with SCSPDB_analysis_eventDailyFG1.ndf files

    Posted Aug 08, 2021 04:22 AM
    Dear Team,

    We have Symantec DCS environment configured with MS SQL 2016 server.

    All of sudden in the past couple of days SQL Data drive became full.  Data drive is keep getting filled with file name called "SCSPDB_analysis_eventDailyFG*.ndf"  (2200+ files in 3 days)

    Also we see the below error on "sis-agent.0.log"file

    1105:Could not allocate space for object 'dbo.CSPEVENT'.'CSPEVENT_PK' in database 'SCSPDB' because the 'cspeventDailyFG216' 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.

    Note :- Transaction logs are configured on separate drive. 

    Regards,
    Sankara Subramanian


  • 2.  RE: SQL DB Data drive is full and getting filled with SCSPDB_analysis_eventDailyFG1.ndf files

    Posted Aug 09, 2021 01:40 AM
    Dear Team, Please share if you have any suggestions?
    Original Message