Link to home
Create AccountLog in
Avatar of PDSWSS
PDSWSS

asked on

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

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?
SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of PDSWSS
PDSWSS

ASKER

Thanks for the suggestions. As soon as I have time I will test them.  
Avatar of PDSWSS

ASKER

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
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of PDSWSS

ASKER

Thanks. That solved it.
>>Thanks. That solved it. <<
Excellent!  Now please close the question.  Here is how:
https://www.experts-exchange.com/help.jsp#hs=29&hi=407
Avatar of PDSWSS

ASKER

Together these 3 experts provided a complete answer. Thanks