In a previous blog entry, I talked about the new FILESTREAM data capability in SQL Server 2008 where we can store Binary Large Object (BLOB) data on the file system but have it transactionally part of ...

Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

SQL Server SQL Server 2005 introduced the much awaited Database Mirroring feature. OK, so we had to wait for SP1 for official support and for SQL Server 2008 for some enhancements like better ...

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 ...

SQL Server 2005 is so packed with new features that it can be hard to keep track of it all. Like a tightly packed peloton of Tour de France riders, the new capabilities of SQL 2005 may appear as a ...

Microsoft today announced “Mirroring,” a way for enterprise customers of its Microsoft Fabric product to replicate external databases they use, and to manage them from within Microsoft’s data ...

// disclaimer = based on SQL2008 and mirroring of two SQL DB's on different physical boxes with a witness.<BR><BR>"Pull the plug" would work in the disclaimer setup above (the witness detects one SQL ...

When it comes to mission-critical systems and databases, we all know that we need to plan for disaster. It's not the most exciting work; there's often little reward even when it's well done, and the ...