Solved

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

Posted on 2011-03-08
9
447 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 46

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
 

Author Comment

by:PDSWSS
ID: 35086163
Thanks for the suggestions. As soon as I have time I will test them.  
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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 46

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

919 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