Stueyb

Hi peeps,

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

My limit is drop *

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.

HHxx

What backup software will you be using?

Stueyb

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 !

GaryK

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

HHxx

Or use the Maintenance wizard to create the jobs

stevencotton

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!

Stueyb

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

ozzy

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

Stefan

Stueyb

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 !