<div>
You can use network or mapped drives with a few caveats. &nbsp;The account that you use to start SQL Server has to have rights to access the remote location, and you must keep your server logged on with the same account.<br />
<br />
It's better to access remote location with a UNC path. &nbsp;Just make sure your SQL startup account has rights to the remote location. &nbsp;Then you don't have to keep the server logged on.
</div>


You can use network or mapped drives with a few caveats.  The account that you use to start SQL Server has to have rights to access the remote location, and you must keep your server logged on with the same account.

It's better to access remote location with a UNC path.  Just make sure your SQL startup account has rights to the remote location.  Then you don't have to keep the server logged on.

<div>
&lt;&lt;We need to back up our databse off-site. Ideally I'd like to use Enterprise Manager but EM does not &quot;seem&quot; to allow for netwrok or mapped drives.&gt;&gt;<br />
Actually it does ...You just need to design a workflow wrapped up in a DTS package that includes both VB Script and TSQL operations...All are accesible from Enterprise Manager in Local Packages....<br />
<br />
Hope this helps....
</div>


<<We need to back up our databse off-site. Ideally I'd like to use Enterprise Manager but EM does not "seem" to allow for netwrok or mapped drives.>>
Actually it does ...You just need to design a workflow wrapped up in a DTS package that includes both VB Script and TSQL operations...All are accesible from Enterprise Manager in Local Packages....

Hope this helps....

<div>
<div class="content wysiwyg-content">
We need to back up our databse off-site. Ideally I'd like to use Enterprise Manager but EM does not &quot;seem&quot; to allow for netwrok or mapped drives.<br />
<br />
I'd like to know:<br />
1. Is it possible<br />
2. If yes....HOW
</div>
</div>


We need to back up our databse off-site. Ideally I'd like to use Enterprise Manager but EM does not "seem" to allow for netwrok or mapped drives.

I'd like to know:
1. Is it possible
2. If yes....HOW

How to back up to a remote or mapped drive

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.