question

SahaSaha-5270 avatar image
0 Votes"
SahaSaha-5270 asked Cathyji-msft commented

Database with missing data

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-general
autogrowthlog.jpg (23.9 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SahaSaha-5270,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @SahaSaha-5270,

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.