Discussion:
Backup related databases
(too old to reply)
e***@mailinator.com
2008-10-26 20:02:15 UTC
Permalink
Raw Message
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]
2008-10-27 20:25:10 UTC
Permalink
Raw Message
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
2008-10-27 20:29:45 UTC
Permalink
Raw Message
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.
Loading...