Hello,
I am running Daily Ola Maintenance job Database Integrity Check with following:
DBCC CHECKDB ([ADTDB]) WITH NO_INFOMSGS, ALL_ERRORMSGS, PHYSICAL_ONLY
Error:
database snapshot cannot be created because it failed to start. Msg 1823, Level 16, State 8, Server
Msg 5170, Level 16, State 1, Server ADTSql, Line 1 Cannot create file 'D:\MSSQL12.MSSQLSERVER\MSSQL\DATA\ADT.mdf_MSSQL_DBCC8' because it already exists. Change the file path or the file name, and retry the operation
When I see this ADTt.mdf_MSSQL_DBCC8 file, it's almost 1 TB like database size.
Is it I should move this file somewhere and rerun the job or delete this file?
Is it any another option?
Keeping in mind, as DB size is almost 1 TB so normally we run during early morning but from last 2 days it's having this issue.
When I run following, I am not any data, Result is empty:
SELECT *
FROM [master].[sys].[databases]
WHERE
[databases].[name] = 'ADTDB' AND
[databases].[source_database_id] IS NOT NULL