Hi @emre, I am having trouble with the Backup module and SQL backups… cannot see why… could you please help me out here?
Thanks!!!
SQL Server does not have access permission to backup location. Either
- Change SQL Server service account to
Local Serviceor, - Enter default SQL Server backup path to
Settings > Backup Location.
OK!!! so SAL SERVER BACKUP LOCATION should work good!!!
I´ll try that,
BTW, thanks for the modules!!! they are great!!!
G.
I am experiencing something strange here, backup shows a messages telling me that the backup has been made, but in the backup list screen there are NO backups…
Thanks!!!
G.
Did you checked backup location? Does any file creates there?
no files created there. thanks
G
Be sure your server has access to Backup Location. If you configure a local path as backup location it will be the path on server because SQL Server creates backup. For example if the path is c:\backups backups will be stored in Server. Not on your local machine.
how do i change setting to access permission:
Change SQL Server service account to Local Service or,
Enter default SQL Server backup path to Settings > Backup Location.
can it be done by giving access permission of full control by right clicking on mssql folder
@madiha it relates to the windows account that starts the MSSQL service. You can change MSSQL Service account to an account (eg. local service) that have access permission to backup location.
Below is an example how to change the Access permission
Select the Backup folder on SQL Server.
Right Click and select properties
Select Security
For the required User Account change the Permission…
Click on apply and ok.
2 Likes
Had to add these users:
NT Service\MSSQL$SAMBAPOS
CREATOR OWNER
and give them full rights