Need to perform a DTS backup. HELP!!!!!!!

[cardiffdutch]

I have a SQL 2000 database on a "Live Box" that we do some hosting on. As it is a publice live server it isnt on our Lan. What I want to do is create a backup of the database via DTS, burn to a CD, then place data on our Lan, then add it to our backup exec schedule.

Is this the besy way to do this?

What do I need to do this?

Will the data be encypted when using DTS?

As you can proabaly tell I am very new to this aspect of IT, so your help is greatly appreciated.

 

[JayKusch]

First off ... if you are able to use DTS I am assuming you should then be permitted to create a SQL Server job. If so, create your Job with the first step being the backing up of the DB(s) to disc on the Hosting server. I do not beleive you will be able to spool the backup to the CD directly.

From there, I would think you would need to have a CD that is ready to accept data, pre-burned, in the CD drive. The next step of your job could be to execute an ...

EXEC master..xp_cmdshell 'MyCDBurningApp param1, param2'

Of course I am not sure of the app you are using to burn the data to the CD but I bet you will have some type of parameters to direct it the file moves from disc to your CD.

Once that is done, you should be able to grab the CD and hopefully have your backup software on you LAN pick it up. If not, you may need to have a scheduled/manual Windows task to move it from CD to a disc share for the backup software to back it up correctly.

Good Luck!

Thanks

J. Kusch

 

[mrdenny]

cardiffdutch,
Let me through a different approach at you, and see if this might work any better.

Backup the databases using the normal BACKUP DATABASE commands. Then using xp_CMDShell run a batch file which will FTP the data into your private network.

You could even configure IPSec to encrypt the data as it goes over the wire so no one can read the data.

Now the data is on your internal network, and you can back it up automatically.

And the best part is that it's all automated so you don't have to move the CD manually. You also won't have to come up with a new procedure when your database backup goes over the 650 MB mark.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[JayKusch]

mrdenny's approach sound too! I have used that method myself. The only issue is if the admin of the public server permits you to use xp_cmdshell and to use FTP. Some admins are very strict in how they run thier ships!

Thanks

J. Kusch

 

[cardiffdutch]

What I have decided to do now is to install SQL on one of our servers and am trying to access the database remotely via IP Address. So this will backup to a share on the server and I have added this share to our backup exec schedule.

The problem i am getting now is when I try to connect I get an error saying "Not associated with a trusted SQL Server connection"

I have selected SQL and Windows Auth but no joy.

Here is what I have:-

Windows 2000 Server SP4 (Lan Server) SQL 2000
Windows 2003 Enterprise (Remote Server) SQL 2000

Hope you can help.

Cheers