Share via

Database with missing data

Avyayah 1,291 Reputation points
2021-04-07T21:52:12.79+00:00

One of the database in simple recovery mode has 259GB datafile and 1 MB logfile. After making changed to the Autogrowth of logfile initial size is 33 MB. Do I increase the size of the logfile if so how since this is production? User is experiencing missing data and there are MSSQL_DBCC13 and MSSQL_DBCC18 file found from 2017, which is 300 GB. I don't see any DBCC checkDB running in the server. Is it safe to delete the MSSQL_DBCC files? This server of course was restarted since 2017 and the files did not get deleted

85483-autogrowthlog.jpg

SQL Server | Other
Answer accepted by question author
  1. CathyJi-MSFT 22,401 Reputation points Microsoft External Staff
    2021-04-08T02:43:13.133+00:00

    Hi @Avyayah ,

    > Do I increase the size of the logfile if so how since this is production?

    No, since you enabled auto growth for log file, the SQL server log file will automatic increase 256MB when the log file has no empty space for transaction log. If the log file have sufficient free space, it will not cause any auto growth.

    > don't see any DBCC checkDB running in the server. Is it safe to delete the MSSQL_DBCC files?

    Yes, you can delete these files after you confirm that there is no DBCC CHECKDB command currently being executed.

    These files are the snapshot files created by DBCC CHECKDB command. SQL Server normally deletes the snapshot files when the DBCC completes. If the operating system encounters an unexpected shutdown while the DBCC CHECKDB command is in progress, then these files will not be cleaned up. They will accumulate space, and potentially will prevent future DBCC CHECKDB executions from completing correctly. In that case, you can delete these new files after you confirm that there is no DBCC CHECKDB command currently being executed.

    Refer to this thread What is .mdf_MSSQL_DBCC15 file.

    > One of the database in simple recovery mode has 259GB datafile and 1 MB logfile.

    Suggest you setting the database to Full recovery mode, since you can not backup the log file when the database in simple recovery mode, and your database is in product environment . If the database is corrupt, how did you recovery it?

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.