November 13, 2019 at 8:55 am
I have configured always on and log backup is failing with the error
Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'T:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\LOG' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1) [SQLSTATE 01000]
Msg 22048, Sev 16, State 1: xp_create_subdir() returned error 3, 'The system cannot find the path specified.' [SQLSTATE 42000]
i gave full access to the T drive still getting the same error even i troed to execute from ssms
EXECUTE master.sys.xp_create_subdir N'T:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\LOG';
Msg 22048, Level 16, State 1, Line 0
xp_create_subdir() returned error 3, 'The system cannot find the path specified.'
job is configured through Ola Hallengren script
November 13, 2019 at 9:20 am
I think if you're trying to create the folder "T:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\LOG" then the path "T:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup" would already need to exist. Have you checked that?
John
November 13, 2019 at 9:28 am
I created Always on group AG with space is it reson for failing the job
LIke AG
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply