Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • 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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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