?
Solved

How to back up to a remote or mapped drive

Posted on 2007-11-30
3
Medium Priority
?
218 Views
Last Modified: 2010-04-30
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
0
Comment
Question by:SOakley54
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 20383772
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.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 20384289
<<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....
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 2000 total points
ID: 20384865
Or could use a better backup application such as Red-Gate's SQL Backup:
http://www.red-gate.com/products/SQL_Backup/index.htm
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question