Re: Making security backups with ado

From: Guillem (keinname_at_eresmas.net)
Date: 01/28/04 

Date: Wed, 28 Jan 2004 22:22:55 +0100

I suppose you're right that's the best solution, but I wanted to store the
data in a way that should be completely independent of both the DB and the
DB engine (let's say in another drive or computer) to prevent problems not
only with DB corruption/crash but also with server corruption/crash (virus,
HD broken and so on)

Well, if I don't find another solution, I suppose I'll end up doing what you
suggested.
Thanks very much for your help Viatcheslav!

Guillem

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> escribió en el mensaje
news:4017fd52$2@newsgroups.borland.com...
> The best solution seems to use backup database (or backup tables) instead
of
> storing data with SaveToFile(). You should create new database and copy
all
> backuped records with SELECT .. INTO statement. When you need to restore,
> execute SELECT .. INTO statement to copy records from backup to actual
> store. Most DBMS will let you execute SELECT .. INTO SQL to copy data into
> or from another database.
>

Relevant Pages

  • Re: Offline defrag
    ... I'm not sure I'd bother doing offline defrag. ... create a new Store 1 and move all the users from Store 2 and then ... however I have been going through the event and checking the database size ... If BLB reports corrupt item, it indicates problem with backup software, ...
    (microsoft.public.exchange.admin)
  • Re: mount database with *.edb and all logs Exchange 2007 urgent :>
    ... Can I copy the database *.edb in the original database *.edb? ... Only the store has to be mounted. ... backup files y open teh mailbox that it contein. ... I need restore all mailboxes, i have the backup with the file *.edb and the ...
    (microsoft.public.exchange.admin)
  • Information Store Corrupt - 3rd time!
    ... This is the 3rd time I have had the Information Store get corrupted in the ... Veritas Backup fails and complains that it could not backup the Information ... "Access Denied to Database Mailbox Store - Warning mailbox ... Store is a corrupt file. ...
    (microsoft.public.exchange2000.admin)
  • Iformation Store Corrupt - 3rd time!
    ... This is the 3rd time I have had the Information Store get corrupted in the ... Veritas Backup fails and complains that it could not backup the Information ... "Access Denied to Database Mailbox Store - Warning mailbox ... Store is a corrupt file. ...
    (microsoft.public.exchange2000.information.store)
  • Re: Recovering EDB fFiles
    ... had to restore from last full backup over 6 months old. ... a new store though. ... database as best possible, and it would still only stay mounted for an hour ... start moving mailboxes to a fresh clean one. ...
    (microsoft.public.exchange.admin)