|
Home > Archive > SQL Anywhere database > May 2005 > Double log mirror on a database ??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Double log mirror on a database ??
|
|
| Bassem M. 2005-05-24, 8:23 pm |
| Hi,
I'm using ASA 8.0.2
I want to know if it's possible to do a double log mirror on a database.
In another words, can I have two log Mirror on :
C:\My Documents\MyDatabase
.mlg
and
D:\Test\MyDatabase.mlg
Thank you,
Bassem Mawassi
| |
| Greg Fenton 2005-05-24, 8:23 pm |
| Bassem M. wrote:
>
> In another words, can I have two log Mirror on :
>
> C:\My Documents\MyDatabase
.mlg
> and
> D:\Test\MyDatabase.mlg
I do not believe so. But let me ask...why would you want to?
The transaction log mirror (.mlg) is a direct copy of the transaction
log (.log). Why do you want 3 copies of the transaction log? Typically
you have the .log on one drive and the .mlg on a separate drive (and in
the best case scenario, the .db file on a third drive). Note that these
are separate *drives*, not separate partitions of the same drive.
You can create another copy using the "live backup" facility (dbbackup
-l). You would typically do this from a separate machine.
Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|