I am running Hallengren's IntegrityChecks
job which fails with the following error:
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'T:\SQL_Data\Example.mdf_MSSQL_DBCC9'.
SQL Server Agent service account is NT Service\SQLAgent$INSTANCENAME
, which has full access to the T drive including all sub folders.
Any idea how to overcome this?
Thanks