<div>
EXEC XP_cmdshell&lt;Your mapped drive letter here&gt;&lt;UNC Path to shared drive&gt; <br />
<br />
that should let you back up to a shared drive :)
</div>


EXEC XP_cmdshell<Your mapped drive letter here><UNC Path to shared drive>

that should let you back up to a shared drive :)

<div>
ok<br />
<br />
Is it permanent?
</div>


<div>
it should be <br />
I cannot say with absolute 100% confidence<br />
<br />
you would wnat to do that for each lettered drive you have <br />
<br />
to ensure it being permentant you can alway make that a stored procedure and set it to run at startup or as a job to run at 12:01am every day :)
</div>


it should be
I cannot say with absolute 100% confidence

you would wnat to do that for each lettered drive you have

to ensure it being permentant you can alway make that a stored procedure and set it to run at startup or as a job to run at 12:01am every day :)

<div>
Last question<br />
<br />
Do I run this in SQLTRANSAT?
</div>


Last question

Do I run this in SQLTRANSAT?

<div>
No just in a query window or make a stored procedure
</div>


No just in a query window or make a stored procedure

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I use SQL SERVER 2008R2 and I Wonder if there is a way to perform backups of my databases on a map drive or a foreign server.<br />
<br />
For now I'm able to perform backups only on local drives.<br />
<br />
Thank you
</div>
</div>


Hi

I use SQL SERVER 2008R2 and I Wonder if there is a way to perform backups of my databases on a map drive or a foreign server.

For now I'm able to perform backups only on local drives.

Thank you

SQL SERVER BACKUPS

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.