Backup into individual folders or create timestamps

Hi there,
I am using SQL 2000 SP2 and am trying to establish a viable backup
process. I want to be able to automate backing up databases and then
have them moved to a folder on a file server.
Since I have discovered that I can't backup to a mapped drive I am
having to backup locally. What I want to do though is backup daily and
have it create separate backups per day. I don't want to overwrite
what is currently there, I want it to create a backup called e.g.
Backup_220903, and then on Tuesday create another file called
Backup_230903 and so on.
After that I then need a reliable way of having the files copied
automatically to my remote file server
Does anyone know how I can do this'
Many thanks in advanceYou can backup directly to the network folder.
You need to use the full UNC name. Example :-
BACKUP DATABASE Dbname TO DISK = \\servername\sharename\backup.bak WITH INIT
--
HTH
Ryan Waight, MCDBA, MCSE
"Derek" <dryan@.legendware.co.uk> wrote in message
news:72938c9c.0309220639.55a36e94@.posting.google.com...
> Hi there,
> I am using SQL 2000 SP2 and am trying to establish a viable backup
> process. I want to be able to automate backing up databases and then
> have them moved to a folder on a file server.
> Since I have discovered that I can't backup to a mapped drive I am
> having to backup locally. What I want to do though is backup daily and
> have it create separate backups per day. I don't want to overwrite
> what is currently there, I want it to create a backup called e.g.
> Backup_220903, and then on Tuesday create another file called
> Backup_230903 and so on.
> After that I then need a reliable way of having the files copied
> automatically to my remote file server
> Does anyone know how I can do this'
> Many thanks in advance