• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

SQL Backup trouble

I am using SQL 2005 Management console on a client install of SQL.    I would like to make a backup of my DBs to my local computer.  However, I can not change the drive location from the server drive.   Is there a way to accomplish this?    
0
NetserMA
Asked:
NetserMA
  • 3
  • 2
1 Solution
 
chapmandewCommented:
well, if the server can reach your local computer, you can do something like this:

backup database dbname
to disk = '\\yourmachinename\c$\backup.bak'
0
 
NetserMAAuthor Commented:
usin that method   i'm getting an access denied error.

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\itmanagervista\d$\sqlbackups\pfaidspriorV14.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
0
 
chapmandewCommented:
so, the account you're running the sql server service and agent with cannot access your machine.  Are these 2 services running under domain accounts?
0
 
NetserMAAuthor Commented:
Yes they are domain accounts
0
 
chapmandewCommented:
good...give those accounts permission to get to your c drive on your pc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now