We have a query that we're using to backup our database. But when we run it, we get this error message:
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'C:UsersKimpoyDesktopBackupAcinsoftDB.Bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Here's our query:
BACKUP DATABASE AcinsoftDB
TO DISK = 'C:UsersNameDesktopBackupMyDB.Bak'
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';
We're also using SQL Server 2008. Thank you very much.