T
TheMadDBA
Guest
Like Thomas says... you really have to use proquiet to get a consistent backup of two or more databases at once. Neither DB knows about the other DB so there is no transaction sync between the two. The quiet point forces both DBs to stop writing so you can get a good backup. If you don't use proquiet on both DBs.... You risk having one part of a logical transaction committed in one DB and the other part of that logical transaction in flight in the other DB. When you restore both databases and crash recovery happens the in flight transaction will be rolled back and you are out of sync. EDIT: None of this matters if the databases are independent of each other... like multiple versions of the same application.
Continue reading...
Continue reading...