Hi peeps,

I must confess I know nothing of SQL 7/2000 or the manager stuff etc.

My limit is drop * :D

However I have a webserver with several important databases on it and I need to back it up, automatically, at say 3 am.

How do I do this ? I have searched ntfaq.com and google, but nothing seems to just answer this seemingly simple question.

What backup software will you be using?

I am using Veritas 9which does have an OFA but what makes this a little awkward is that the server with all the db's on it is on a DMZ so obvious security aspects if I punch a hole through the Firewall :)

Basically I need to backup the entire server, dbs, asp stuff etc onto tape on the internal lan !

Stuey,

Well you could run the backup via script using SQL agent which is what I use for all DBs here to copy them to a networked drive which gets backed up. Go to Management->Jobs and create a new job with two steps, call the first step Backup database and add the following TSQL:

DECLARE @BackupFileName varchar(128)
SELECT @BackupFileName = 'F:\Daily Backups\' + DATENAME(dw, GETDATE()) + '<name of db here>.Backup'

BACKUP DATABASE <name of db here> TO DISK=@BackupFileName

Then in the second step call it copy file say, add the following (as an activex script)

Dim BackupFile
Dim Destination
Dim Fs

Set Fs = CreateObject("Scripting.FileSystemObject")

BackupFile = "F:\Daily Backups\" & WeekDayName(WeekDay(Date, 1)) & "<name of db here>.Backup"
Destination = "X:\" & WeekDayName(WeekDay(Date, 1)) & "<name of db here>.Backup"

Fs.CopyFile BackupFile, Destination

Set Fs = nothing

You can then attach a schedule to it to run at a determined time. Using this method you could actually get it FTPed to some online storage space even.

HTH

Gary

Or use the Maintenance wizard to create the jobs ;)

If the box is in a DMZ then the last, last thing you should be doing it mapping shared drives through a firewall to your internal LAN!

Steve,

I realise that but I have no real option to be honest, it needs to be backed up and I have no other option t back it up. Just have to make it as secure as reasonably possible :(

why not just stick a local copy of Veritas on the box?

Stefan

ozzy, it doesnt have a tape drive :(, its a mirrored 1u box. If it had been me, not my boss, i would have ordered a raid 5 with tape drive !