What software should I get for Backups?

[SemperFi]

I have a database on a server that is not easily accessable that I want to backup daily. I want to be able to bring it to a client computer and burn on cd. If nothing else bring to the hard drive of the client and I can burn later. Oh and another thing it needs to be easy. Something that can scripted or configured so one click is all it takes. The guy running it has been using a computer for a couple of months and didn't really want to start using one.

I thought I could use the back up in windows but I can't seem to get that to work.

Any input, ideas, suggestions are appreciated.

 

[Pirotech]

hmm, to backup database, first you need to stop it and then backup. I know that true image have a snapshot utility which is included in true image workstation version.

In common case if your database supports transactions, snapshot technology guarantees that only transactions active at the snapshot creation moment may be corrupted.

So after restoration, the database should roll back such transactions and the database becomes consistent. The only active transactions' data will be lost. If you agree with above, you do not need any other efforts. If you want to save consistent data, you have several ways: If you are working in the GUI mode, you should use 'Pre/post commands' in 'Backup Creation Options' to stop your database before the backup starts and restart it after the backup is completed or use 'Before/after data capture commands' to suspend the database for a short period of time required for making a snapshot of data being backup up.

 

[Czar]

make a database dump to a text file, write that to a cd/dvd

 

[SemperFi]

There is no problem stoping the database. We close it at the end of the day. My problem is the guy who runs the computer is an old fellow who is just learning how to use the ticketing program. Showing him how to backup is not an option. I still have to enter new customers for him. He is learning but slowly.

Whatever I use has to be able to be automated. So at the end of the day he shuts down the program, closes remote desktop, then clicks an icon to do the backup, then he shuts down his computer. Whatever I use has to be able to work on a network drive. I downloaded that paragon exact image that was in the hot deals section a few days back. It wouldn't create an image of the network drive. I am thinking that is the reason windows backup utility wouldn't work either.

 

[Czar]

do a text dump as a schedule, another schedule to copy it someplace else