June 30, 2010 at 6:19 am
I would like to use a Maintenance Plan to back up my primary server to a backup server. The Wizard does not give me the option of selecting a directory that is not on the primary server. So I tried to build the plan using the SSIS design application. The only way I have been able to connect to the remote server is to use my domain account. Do I have to use a domain account to accomplish this?
June 30, 2010 at 7:25 am
nano2nd (6/30/2010)
The Wizard does not give me the option of selecting a directory that is not on the primary server.
1- Share a directory on remote server
2- On primary server map remote server directory as a drive... like Z:
3- Point backup wizard to drive Z:
Please be aware that depending on network bandwith and size of the backups this solution may back fire.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 30, 2010 at 8:21 am
To backup on the network, you need to use UNC - \\servername\sharename\backup.bak
June 30, 2010 at 8:23 am
To backup on the network, you need to use UNC - \\servername\sharename\backup.bak
June 30, 2010 at 10:59 am
Thanks for the tip. I had to set the share up as "everybody" read/write. I was not able to find a way to specify the primary server in the "Choose people to share with" dialog. I really wanted to share with just the primary, but the primary doesn't have a domain account.
June 30, 2010 at 11:01 am
Thank you for the tip about the share name. I'm not sure I have the share set up quite right yet. See previous post.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply