Printable View
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
What type of database is being used?
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.