Without using any special hardware, it allows you to duplicate (real time mirroring) a production database on another SQL Server at a different location. In addition, if the first server should become ...

We have Database Mirroring set up (SQL 2005), but what is the proper way to mirror SQL Agent Jobs? We have quite a few custom jobs. Is it just manually scripting out the jobs from the Principle and ...

On the other hand, the promised data mirroring capability will not ship with the final product in November in complete form so it can be further tested, he said. The goal is to have mirroring ...