<div>
well, if the server can reach your local computer, you can do something like this:<br />
<br />
backup database dbname<br />
to disk = '\\yourmachinename\c$\back<wbr />up.bak'
</div>


well, if the server can reach your local computer, you can do something like this:

backup database dbname
to disk = '\\yourmachinename\c$\backup.bak'

<div>
usin that method &nbsp; i'm getting an access denied error.<br />
<br />
Msg 3201, Level 16, State 1, Line 1<br />
Cannot open backup device '\\itmanagervista\d$\sqlba<wbr />ckups\pfai<wbr />dspriorV14<wbr />.bak'. Operating system error 5(Access is denied.).<br />
Msg 3013, Level 16, State 1, Line 1<br />
BACKUP DATABASE is terminating abnormally.<br />

</div>


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.


<div>
so, the account you're running the sql server service and agent with cannot access your machine. &nbsp;Are these 2 services running under domain accounts?
</div>


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?

<div>
Yes they are domain accounts
</div>


<div>
<div class="content wysiwyg-content">
I am using SQL 2005 Management console on a client install of SQL. &nbsp; &nbsp;I would like to make a backup of my DBs to my local computer. &nbsp;However, I can not change the drive location from the server drive. &nbsp; Is there a way to accomplish this? &nbsp; &nbsp;
</div>
</div>


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?    

SQL Backup trouble

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.