Cannot open up backup on SQL Server 2008 database

1152335 pts.
Tags:
Backup
SQL Server 2008
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'
WITH FORMAT,
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';
We're also using SQL Server 2008. Thank you very much.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: