Backup Server question...

[bessebo]

We are in the process of implementing a backup server in case of database inaccessibility on the primary server. My backup strategy on the one server has been to have one backup device for my database and perform full backups every night which overwrite this backup device. During the day I run transaction log backups every 15 minutes which append to the same backup device. This works well for us since the full backup overwrites every night and the transaction log backups append during the day to the same device.

With our new scenario with keeping a refreshed backup server that is updated from backups run on the primary server, it appears that I need to have 2 backup devices, one for the full backup and one for the transaction log backups. The reason being that we will probably copy the full backup nightly over to the backup server and restore it on the backup server. Then during the day we will have the transaction log backups write to another device that we will copy off to the backup server (and don't restore it unless there was a need to).

We would probably just copy the transaction log backup over to the backup server every 15 minutes just overwriting the backup that is currently on the backup server. Before the full backup runs that night we will make that final copy of the transaction log backup over to the backup server. At that point I will have to refresh the transaction log backup device so that the next morning the log will start with only new changes.

Should I have the 1st transaction log backup each morning simply overwrite the previous day's transaction log backups or is there some other way to do this? Is this scenario typical for backup servers? I am interested in anyone else out there who has a backup server refreshed daily for disaster recovery purposes and how they go about doing what I mentioned above.

Thanks,
Bessebo

 

[deathstar]

I'm constantly having a problem with my new server that I just newly installed. My problem is that I'm trying out the Windows 2000 NTBackup utility and I'm getting nothing but headaches. I've read the Microsoft Q articles and I've done everything on their suggested fixes from installing the new service packs 1 & 2, to installing a new serive that will read the tapes (Srvany), everything I've tried I've hit a brick wall. Since I stumbled onto this forum I'm gald to hear that I'm not the only one who has encountered this problem.

My main problem is that RSM doesn't seem to register any new or used tapes I put in the server. I know that RSM is supposed to reconize the media before it can use it in its library for backups. I have tried this on a brand new server with a Netfinity 5100 with a SCSI Seagate DAT internal device and also a HP Netserver E45 with a HP Surestore 6000 device attached. I get the same results with both servers !!! When I place in a tape the server can not immediately reconize the tape and I'll usually have to perform a manual reboot and once the server boots up it'll then see the new media and I can then run a test backup to access the tape for backups. My second problem is that whenever I change tapes from one day to another it will not reconize that the tape has changed and I keep getting and error "Removable Storage did not mount the requested media. The operation was aborted."

I'm out of my wits end can some please help me in this matter, your help would be greatly appreciated

 

[strike]

for like 2 weeks now the backup exec on my server has been completing the backup but failing at the end of the backup for some reason. can anyone help me with this problem that im haveing.