red-gate.com

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Hi rrjegan17

thanks for this, I do indeed have a trial version and I am backing up one of my local databases as we speak (type!)

I am still a bit concerned about how i being the .bak into my office network. For example I could create a vpn to connect to server in mexico. I could then connect to the server using red-gates sql_backup and back up the db, or I could create a schedule to back up the db, my concern is, how, using this tool could I bring the .bak onto my server? is this where I use the copy back up to folder tick box, i have attached a screen shot to make my explaination clearer....
sqlback.doc

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

thanks chaps.....i think :)

>> hope you referred to this<<
Actually, no. You are referring to the CONVERT parameter and not a utility, which would assume that you have a license to use SQL Backup.

I was referring to the sqb2mtf.exe command line utility:
http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Backup&c=SQL_Backup/help/6.0/SBU_SQLBackupFileConverter.htm
This does not require a license and allows you to send a compressed and encrypted file in sqb format to a client that does not have SQL Backup and they can restore using MS SQL Server.

ASKER

thanks acperkins,

all i am really trying to do is find a quick way of bringing a .bak file from a server in South Africa that is not networked to us, any ideas? if you do have any ideas other than using a ftp site and you want me to raise a new question please let me know :)

>> all i am really trying to do is find a quick way of bringing a .bak file from a server in South Africa that is not networked to us,

What is the size of that file and about Internet speed in both locations

ASKER

hi rrjegan17

I believe it is standard band with and the .bak is 4G