July 1, 2014 at 11:18 pm
Hi All
Under the maintenance plan, i run full backup at the same path and it was successful. The maintenance plan for selected database was run success.
BUT when i want to write the backup report "Write a report to a text file" i receive this error in maintenance plan "view history"
Access to the path 'F:\\MSSQL11.APPSPRD\\MSSQL\\Backup\\Backup Log\\CARS\\CARS DB Backup_Subplan_1_20140701200011.txt' is denied.
Basically i am using defaul NT service for SQL Agent
July 2, 2014 at 1:28 pm
adzuanamir (7/1/2014)
Hi AllAccess to the path 'F:\\MSSQL11.APPSPRD\\MSSQL\\Backup\\Backup Log\\CARS\\CARS DB Backup_Subplan_1_20140701200011.txt' is denied.
Basically i am using defaul NT service for SQL Agent
Looks like your service account does not have write access to the path your specified.
By default the log path is "\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log". Since this is not the default path or the path specified during the install, SQL was not given write access to the folder.
If you check the security on the folder, the service account group will only have read access. You need to add modify access and make sure it inherits it down to files/subfolders.
July 2, 2014 at 6:41 pm
Hi SSC-Enthusiastic
Logically:
1. I am using SQL agent services tu run the maintenance task for full backup and backup log
2. The location for both task located at same location which is at the same partition except at different folder.
3. The full backup is success BUT how come backup log write operation is failed (denied) although full backup also require read and write permission.
But i will take note on the default location as you mentioned here :
"By default the log path is "\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log". Since this is not the default path or the path specified during the install, SQL was not given write access to the folder."
How can i change the log location to its default location?
July 15, 2014 at 4:54 pm
adzuanamir (7/2/2014)
Hi SSC-EnthusiasticHow can i change the log location to its default location?
Connect to the server using SSMS.
Right click on the server registration and select properties.
Click on Database settings.
You will see Database default locations.
adzuanamir (7/2/2014)
Hi SSC-Enthusiastic1. I am using SQL agent services tu run the maintenance task for full backup and backup log
...
3. The full backup is success BUT how come backup log write operation is failed (denied) although full backup also require read and write permission.
You should test this. Log onto the server using the service account and/or use Runas function and open SSMS.
Do a backup of the database to that exact path and confirm the results. Now do a backup of the log to the exact path and confirm the results.
2. The location for both task located at same location which is at the same partition except at different folder.
This seems to indicate you may have the same root path, but different subfolders which can be cause by what I mentioned.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply