?
Solved

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

Posted on 2011-03-08
9
Medium Priority
?
463 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
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 53

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 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 400 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 600 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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 53

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

571 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