CODEWITHSUNDEEP
sqlsql-serverbackup
hamid
hamid

Reputation: 31

SQL backup error (Operating system error 5(Access is denied.))

I get this error while I want to get a backup of my files ,although I must say that I connect to another persons PC with (remote desktop connection):

Backup failed for Server '10.72.47.239\gis'. (Microsoft.SqlServer.SmoExtended) ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Cannot open backup device 'F:\FON_BackUp\ABPDN_DB\ABPDN_DB_backup_2022_01_19_000011_4538135.bak'. Operating system error 5(Access is denied.). (Microsoft.SqlServer.Smo)

I would very much appreciate if someone can help me out on this.

Upvotes: 1

Views: 4114

Answers (1)

Kumar
Kumar

Reputation: 11

Give a permissions to that file which one do you want to get a backup file

Go to file right click and go to the property and go to security and there select which server is connect that database and there give file permission and click ok

Upvotes: 1

Related Questions