Re: Copying Tables



DS <bootybox@xxxxxxxxxxxxx> wrote in
news:OoxEi.243$em3.241@xxxxxxxxxxxx:

I have a question. My database is split. I want a backup copy of
my tables in another database on a different machine. Should I
use transferdatabase to get the info into the backup copy or
should I link the backup copy tables to the original database?
What happens if the original databse gets corrupted? Can I get
the table info into the original databse easily?
Any help appreciated, I'm still a little confused on this issue.
Thanks
DS

The best answer to that is neither transferdatabase nor linking is a
real backup solution. Simply exit the application and copy the back
end to your archive area usaing Windows.

I prefer to also rename the file to add a datestamp in hte filename,
so that you can keep last night's backup, and the night before, and
before. Often corruption will only manifest itself several daya
after occurence.

If your primary backup gets trashed, you simply copy the most recent
uncorrupted backup from the archive over the corrupt .mdb

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

.



Relevant Pages

  • RE: Information Store Corrupted
    ... depend on the kind of storage you are using. ... If the corruption is a database structure page you will not ... The backup by definition doesn't include the corrupted items. ... Category: Database Page Cache ...
    (microsoft.public.exchange.admin)
  • Re: Copying Tables
    ... copy of my tables in another database on a different machine. ... Should I use transferdatabase to get the info into the backup ... "Corruption will only manifest itesl ... want a transaction by tranaction copy of my database so that I ...
    (microsoft.public.access.formscoding)
  • Re: Copying Tables
    ... copy of my tables in another database on a different machine. ... Should I use transferdatabase to get the info into the backup ... "Corruption will only manifest itesl ... want a transaction by tranaction copy of my database so that I ...
    (microsoft.public.access.formscoding)
  • Re: Copying Tables
    ... of my tables in another database on a different machine. ... Should I use transferdatabase to get the info into the backup ... "Corruption will only manifest itesl ... want a transaction by tranaction copy of my database so that I ...
    (microsoft.public.access.formscoding)
  • Re: Corrupt Mailbox Store
    ... Either of these steps will eliminate the corruption. ... If the database does not mount then you will have to resort to restoring the ... You will want to use the backup log as well as the application log to ... determine if this is a hardware problem. ...
    (microsoft.public.exchange2000.information.store)