Solved

How to back up to a remote or mapped drive

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
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.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

895 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now