Remote backup over VPN?

[dandrade]

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

[Jason Cook]

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

[dandrade]

[dandrade]

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.

[Jason Cook]

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

[Amanda08]

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

[kasheswari]

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

[Ayelen]