Backup related databases

[e***@mailinator.com]

Hi,

If I have two or more databases that should remain logically
consistent, what would be the way to accomplish that within ASE?
Microsoft has implemented that with marked transactions (described in:
http://msdn.microsoft.com/en-us/library/aa196684(SQL.80).aspx ).
Closest seems to be restoring with the load with until_time option,
but that probably won't guarantee logical consistency.

Regards,
Erwin

[Sherlock, Kevin [TeamSybase]]

You could use replication server to replicate a stored procedure which
invokes an open server (or xp_server) to initiate a backup.

Post by e***@mailinator.com
Hi,
If I have two or more databases that should remain logically
consistent, what would be the way to accomplish that within ASE?
http://msdn.microsoft.com/en-us/library/aa196684(SQL.80).aspx ).
Closest seems to be restoring with the load with until_time option,
but that probably won't guarantee logical consistency.
Regards,
Erwin

[peter collard]

Post by e***@mailinator.com
Hi,
If I have two or more databases that should remain logically
consistent, what would be the way to accomplish that within ASE?

In rep server systems an rs_dumpdb syncs the dumps.

The normal point of consistency on a dump is at the end of phase 2.