Red Gate forums :: View topic - Remote backup over VPN?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

Remote backup over VPN?

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
dandrade



Joined: 30 Sep 2007
Posts: 6

PostPosted: Tue Oct 30, 2007 8:13 pm    Post subject: Remote backup over VPN? Reply with quote

I'd like to manage the whole backup/restore process over VPN. I am mostly concerned with:

** Server Component Installation, because I will be doing this from my laptop, miles away from main server

** Step 3 of the Backup wizard, because I need files to be written to remote server

If folder in my remote box is something like C:\Program Files\Microsoft SQL Server\MSSQL$SQL2000\BACKUP\ and I have admin privilege to C, and I can access it like a shared C$ can I just reference remote folder as

\\192.100.150.1\C$\Program Files\Microsoft SQL Server\MSSQL\BACKUP

Anyway, are there any instructions on how to do this or anyone done this before? (please advise on issues)

Thanks
Back to top
View user's profile Send private message
Jason Cook



Joined: 01 Jun 2006
Posts: 180
Location: Cambridge, UK

PostPosted: Tue Oct 30, 2007 8:18 pm    Post subject: Reply with quote

To answer your queries:

* The Server Component Installer is a small file (about 2MB) that installs all of the stored procedures and service resources required for SQL Backup to function correctly. This only needs to be done once for each server (and again when you upgrade), and should take a couple of minutes to do - even over a remote connection.

* In the wizards, the file locations are relative to the *local* server, so the c:\program files\... location referred to in the wizard will be for the drive local to the SQL Server instance. The only time you would need to consider something like the C$ share would be if the SQL Server instance is on your laptop, and you want to transfer the file to the remote machine.

Hope that helps,
Jason
Back to top
View user's profile Send private message Send e-mail
dandrade



Joined: 30 Sep 2007
Posts: 6

PostPosted: Tue Oct 30, 2007 9:03 pm    Post subject: VPN fine, how about licenses? Reply with quote

Jason Cook wrote:

* The Server Component Installer ... only needs to be done once for each server ...

* In the wizards, the file locations are relative to the *local* server ....


Your post helped, already tested and everything went fine.

I'll be running SQL Backup 5.2 on my laptop and backups are for remote servers. I ran wizard and can see remote IP on the left pane. There is this button next to IP, it says "Trial. Click to activate license."

Do I need one license for each remote IP (server)?
Back to top
View user's profile Send private message
dandrade



Joined: 30 Sep 2007
Posts: 6

PostPosted: Tue Oct 30, 2007 9:29 pm    Post subject: Reply with quote

Never mind, found it in Help file.

Licensing
You can register any SQL Server instance with SQL Backup, but you must have a license for each server on which you want to use the SQL Backup backup and restore features.

It is going to be expensive to provide remote DBA services, but I am glad it works.
Back to top
View user's profile Send private message
Jason Cook



Joined: 01 Jun 2006
Posts: 180
Location: Cambridge, UK

PostPosted: Wed Oct 31, 2007 2:39 pm    Post subject: Reply with quote

To clarify, SQL Backup is licensed per machine; but this licensing only applies to the SQL Server instances running the SQL Backup server components. The SQL Backup GUI can be run on as many machines as you like, without requiring additional licenses.

This means if you have one SQL Server, and 10 DBA's connecting remotely to it; you will only need the one license.

If you have any more questions about licensing, the best people to talk to is our Sales team, who can be contacted at sales@red-gate.com

Hope that helps,
Jason
Back to top
View user's profile Send private message Send e-mail
Amanda08



Joined: 08 Jul 2011
Posts: 1

PostPosted: Fri Jul 08, 2011 9:02 am    Post subject: Reply with quote

Remote backup service works it is important to understand the process of remote backup. When you save files on your computer are stored on your hard drive which is more important than the hardware inside your computer that stores your important files. If you move files from one computer connected to another in the same room you are saving files using the local server. If you move the files over the Internet from a remote server to keep sending their remote location.

Virtual Appliance
Back to top
View user's profile Send private message
kasheswari



Joined: 25 Oct 2011
Posts: 1

PostPosted: Sat Oct 29, 2011 6:25 am    Post subject: Reply with quote

Is there a way to setup a VPN connection for a home network..? I have a home network that i want to access from a my dad's house. Is there a way for me to setup up a vpn connection so i can access the information i need, and if so what type of software or hardware do i need?
________________________
market samurai ~ marketsamurai ~ marketsamurai.com
Back to top
View user's profile Send private message
Ayelen



Joined: 05 Dec 2011
Posts: 1

PostPosted: Tue Dec 06, 2011 2:40 pm    Post subject: Re: Reply with quote

Neutral
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group