Guys, I am currently backing up a huge ISAM database, and it takes a while since it has to be a daily full. So my thinking is to use NBU Accelerator.
Do any of you know if by using Accelerartor if the integrity of the database backup will be in good order, and/or could I potentially run into issues whne I restore?
The only thing that I know about ISAM dbs, is that they are flat files, and I am not sure how they behave in terms of changes, since if using Accelerator each full will be a synthetic backup (a funky-dunky differential).
I hope all this makes sense.
Can't tell - Who is the vendor of the database. ISAM is just a acronym for " Indexed Sequential Access Method". Maybe Accelerator is the right choice maybe not.
Has the vendor a approved backup method ?
Yes, we do a MS-Windows backup of the volume which has a copy of the database, which just takes forever. And as I stated before, I would like to speed up the process by doing a client dedup with Accelerator on a daily full. The volume is on a SAN, but we do not have an NDMP license.
I think I'd try to make the Windows server that this DB is located on a media server and put a 2nd dedicated GB NIC card or fibre HBA in it just for the backup connected directly to the backup LAN/fabric and let it back itself up to the backup resources. Do you have any extra media server licenses around?
....we do a MS-Windows backup of the volume which has a copy of the database ....
Are you using some sort of snapshot technology?
Have you tried to restore from these backups yet?
If existing backup method is good (i.e. successful restore), then dedupe with Acellerator seems like a good idea.
@Marianne: Yes, we terminate all connections to the db, since we do not have the ability to quiese the ISAM db, then we take snapshot of the volume hosting it, and mount/copy the snapshot to another server, then kick-off an NBU backup. This process I wish to make more efficient by using Accelerator and/or someother solution. The entire process takes a while since the db is large; Snap mount/copy, backup and restore to validate.
The restore is validated daily so the integrity of the NBU backup is good. I am hesitate to employ Accelerator, since I am not sure how the ISAM files behave in terms of how Accelerator will determine if an actual file changed, since ISAM is all index based flatfile database. I hope this makes sense.