Cannot open backup device. Operating System error 5.

Question

Hello everyone,

Below is the Query that I am using to backup (create a .bak) for my database. However, whenever I run it, i always get this error message:

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'C:\Users\Kimpoy\Desktop\Backup\AcinsoftDB.Bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

This is my query:

BACKUP DATABASE AcinsoftDB
TO DISK = 'C:\Users\Name\Desktop\Backup\MyDB.Bak'
WITH FORMAT,
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';

Thanks in advance.

Answer 1

The SQL Server service account does not have permissions to write to the folder C:\Users\Kimpoy\Desktop\Backup\