Solved

How would I backup an SQL 2008 DB on a remote computer using Maintenance Plan Wizard?

Posted on 2011-03-08
9
454 Views
Last Modified: 2012-08-13
I would like to schedule backups of our SQL 2008 DBs onto a remote computer using the
Maintenance Plan Wizard. I see how to do this on a local computer. However, the option to
use a shared drive is not offered. How would I do this?
0
Comment
Question by:PDSWSS
[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
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 51

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 35081888
You won't see the share when you create the maintenance plan but you can write full path (something like
\\ComputerName\ShareName
). Will work fine.

Good luck
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 100 total points
ID: 35083104
Make sure the startup account for the SQL Server and SQL Server Agent services have the appropriate permissions (they are not Local System accounts)
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 150 total points
ID: 35083511
If you're talking about using a mapped drive, that's not available because the SQL Server doesn't see the mapped drives the user sees, since they run in different sessions. If you just want to back up to a remote location though, you can just provide the UNC path to your remote folder in your backup location - something like "\\REMOTESERVER\SomeBackupFolder\".

Also, you have the option of setting up your maintenance plan on another server and then taking backups from your main server and storing them locally (on the remote server). To do this, you'd create the maintenance plan on your remote server, and at the top of the page, where it asks you what connection you'll be backing up, point it to your SQL Server.
0
Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

 

Author Comment

by:PDSWSS
ID: 35086163
Thanks for the suggestions. As soon as I have time I will test them.  
0
 

Author Comment

by:PDSWSS
ID: 35109205
I get the attached error when I enter   \\server\shared$    even though the server is not mapped to this drive.

What is causing this?  Thanks
Picture-3.png
0
 
LVL 51

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 35109501
You need to give a filename:  \\server\shared$\filename.bak
0
 

Author Comment

by:PDSWSS
ID: 35110204
Thanks. That solved it.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35113689
>>Thanks. That solved it. <<
Excellent!  Now please close the question.  Here is how:
http://www.experts-exchange.com/help.jsp#hs=29&hi=407
0
 

Author Closing Comment

by:PDSWSS
ID: 35116018
Together these 3 experts provided a complete answer. Thanks
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
Make the most of your online learning experience.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

615 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