It does not matter if you use XCOPY or SHARECPY, your backup will not be good if people are updating the database when you do your copy. If you copy the files while an update is happening, your files for your backup will be out of sync. There is nothing to ensure that the #1 file is in sync w/ the #2 file when you copy an open database. Yes you can copy them in multi user, but I would not want to depend on it. Example: User 1 inserts record into a table, and at the same time user 2 does a SHARECPY.
To insert a record into the database, you have to (A) read the #1 file to get the end of the table in the #2 file. (B) You then have to insert the record in the #2 file, (C) then go back and update the #1 file with the new end of the #2 file and incriment the row counter, and (D) go update the indexes in the #3 file. Now if user 2 starts the Sharecpy and may back up the #1 file before user 1 does step A, but by the time user 1 gets done copying the #2 the new record may already be in the #2 file. Now the copied #1 and #2 files are out of sync. If your database is not too big, you could use the UNLOAD command and dump the whole database out to a file. If your database is very big, you need to put an update date & time stamp on every table, and then you could unload data by the time stamp so you don't have to dump out everything each time. Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 5/03/02 1:17 pm >xCopy will copy a live database. I have done this. Usually the copy is usable, but >sometimes it has to be sync'd, depending upon what was going on in the db when it was copied. There was an old rbase utility with 4.5+ called sharecpy.exe, as >well. > >"Steve Durham" <[EMAIL PROTECTED]> wrote: > >> >> >>I am designing a disaster recovery procedure that will require me to copy a >>live Rbase 6.5++ database approximately five times a day. I am looking for >>some suggestions. The database does use an ODBC driver to an archived >>database of older data prior to upgrade of 6.5++. If the database server >>were to go down, I would like to have another copy of the database at an >>off-site location, and redirect users on Citrix to that off-site server. I >>am beginning to research the best possible way to do this if possible at >>all. I am open for suggestions. I thank you all in advance. >> >>Steve Durham >>Blue Ridge Paper >> >>_________________________________________________________________ >>Chat with friends online, try MSN Messenger: http://messenger.msn.com >> >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> > > >__________________________________________________________________ >Your favorite stores, helpful shopping tools and great gift ideas. Experience the >convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ > >Get your own FREE, personal Netscape Mail account today at >http://webmail.netscape.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
