Solved

How to back up to a remote or mapped drive

Posted on 2007-11-30
3
216 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 500 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

705 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