Veritas Backup Exec 10.d ...NOOB question

[dublin101]

Hi there...i just took over at a place which is using veritas backup exex 10.d...

the outgoing admin told me that it is scheduled to run a backup of one database folder every day for 15 days, and then to start again............meaning 15 individual backups...........

i went into the backup external HDD and realised that there is only one and the job just keeps overwriting the same one.........

now if i want, lets say 7 daily full backups, do i have to creat one back up job and ask it to do 7 new ones, OR, do i just create 7 backup jobs and schedule them to run on .eg

job 1. copy folder on mondays,
job 2. copy folder on tuesdays,
job 3. copy folder on wednesdays,


any suggestions appreciated.

thanks

 

[umbletech]

Hmm can't say I'm an expert but my experience with BE so far is having multiple jobs seems more reliable.

One gotcha don't copy the job. Because when you change the properties all the copies will change too!

 

[fdalmoro]

I'm in the process of working with backing up to file but have been backing up SQL for a long time to tape. First, the best way to backup SQL is to do it through the SQL server via the MS Enterprise manager to a file. It will require that the SQL Agent service is running. Backup SQL to a file on the SQL server nightly and then backup that file to an external drive via Backup Exec on a nighly basis.

Second. Mess around with Media Sets and create one that will have Overwrite protection for 15 days. Use that media set with the SQL job that backs up the SQL database to the external drive. What will happen is that Backup exec will create 15 bkf files on the external drive. One for each night. The oldest one will be overwritten.

I hope that helps.

Fernando

 

[Chris1980]

I'm not entirely sure I understand what you are trying to achieve. Do you mean it is backing up one different database every day until 15 databases are backed up or are you backing it all up every day for 15 days?

I'm not all that used to backing up to disk as apposed to using tapes but either way the jobs shouldn't just be overwriting the data from the last backup. Have you create dmedia sets with overwrite protection periods on them?

 

[Chris1980]

As for using Enterprise manager to backup SQL first I'd say you are duplicating a task. If you have a Veritas SQL Agent licence then veritas will take care of the SQL side of things itself.

 

[dublin101]

its ok guys i've figured it out...........

created 7 folders, monday, tuesday, wednesday, etc

create 7 backup-to-disk folders and named them accordingly and pointed each to the folder

then created 7 jobs, each scheduled for the day

 

[tumane]

hi there! i have just started a new job where Veritas Backup system is been used. i have 3 tapes of size 200GB. but i have not managed to do any backups, as the system always says i have insereted an overwrite protected media, though i have set it no overwritable, and not appendable!

am i misssing something here?

 

[dublin101]

check out the tape physically and maybe it is set there to "read only"...

there will be a small thing on the side of the tape...look around and you'll find it.

cheers