?
Solved

How to back up to a remote or mapped drive

Posted on 2007-11-30
3
Medium Priority
?
223 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
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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

590 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