Hi Jason,
If the database is still live you never can be sure changes were made during the backup process, unless the DBMS itself is provided with facilities for this. So it does not sound as a good idea to me the way you are doing it right now. To give an example: The four files are strongly related to each other, if a row is added in file #2, which influences also file #4 and #3) and #3 and #4 are already done, your database will be corrupt. So I strongly advice to change this procedure. Tony From: [email protected] [mailto:[email protected]] On Behalf Of Jason Kramer Sent: vrijdag 4 juni 2010 1:56 To: RBASE-L Mailing List Subject: [RBASE-L] - Backup Question I have seen several backup questions recently, and they got me thinking. All of the answers in the group have required unloading the database. I use Cobain Backup (I don't remember if link posting is against the rules, so I won't post the link, but you can find it easily), which is a freeware backup program. It is simple, and works very well. The important thing about it is that is uses VSS, so the database is backed up live (restores, of course require a user disconnect). I never have to lock out my users. This brings me to my question, which is, is backing up the database live (using VSS, not some oddball hack to trick the database or OS into thinking that it is offline) a bad idea? Thanks, Jason -- Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax)
