Data Backup Strategies

[selicon.valley]

I have developed General Ledger application in vb6 so my client need backup of data but unfortunately I don’t know the strategies please guide me the different strategies that I can backup my client’s data easily .and also provide details of techniques breifly database sometimes i use is ms acess and sql server 2000

[Hack]

What type of database is being used?

[szlamany]

You mention ACCESS and SQL 2000...

Are you using both?

With MS SQL - you create a maintenance plan that runs on the server.

This should make a FULL BACKUP on some cycle - let's say every night when the users leave.

Then you also have it make a transaction-only backup every so often. Could be every hour - could be every 5 minutes.

How often you make this backup determines how much could potentially be lost due to hardware failure.

Of course you need to backup to a different disk then the MDF/LDF.

Or maybe move the backups to a different server (after they are produced - of course).

As for ACCESS - if that is the backend - I believe people suggest making a copy of the file upon entry or exit from the program. But I'm not an ACCESS person - so that's a guess.