description: Learn about the interoperability of using database snapshots with database mirroring to offload reporting in SQL Server.

When the mirrored database is synchronized (that is, when the database is in the SYNCHRONIZED state), the database owner can initiate manual failover to the mirror server. During a manual failover, ...

Explore essential factors before setting up SQL Server database mirroring, from hardware specs to high availability and failover strategies.

SP1 encompasses several new features, including database mirroring, in which the primary production server is mirrored at all times by a standby server.

In my previous testing and in subsequent SQL Server 2008 classes, I used the AdventureWorks2008 sample database which is set up for Filestream data.

Database mirroring, a high-availability feature, will be included in the RTM version of the Standard and Enterprise editions of SQL Server 2005, but customers will be required to go through extra ...

When SQL Server 2005 is released to manufacturing in the next few months, Microsoft will take the exceptional step of designating one of its high-profile features as being intended for evaluation only ...

As I understand it if you are using mirroring on SQL server and have failover setup you can adjust the connection strings of your applications that use it so they know the name of the other server ...

In this case, you may need to stop database mirroring, take a log backup that truncates the log, apply that log backup to the mirror database and restart mirroring. Disk Space ...