Database Mirroring

Database Mirroring Automating Failover for Multiple Databases

  • Article

Database Mirroring was released with SQL Server 2005 and is becoming a popular choice for a failover solution. One of the big issues with Database Mirroring is that the failover is tied to one database, so if there is a database failure the mirrored server takes over for this one database, but all other databases remain functional on the primary server.


4,007 reads


T-SQL Tuesday Live–7 Apr 2020


Last week went a little crazy, and I learned something: don’t post a Zoom...

Getting Your dbatools Version–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

SQL Server and VMware Resource Pools


Resource pools are used to hierarchically partition available CPU and memory resources, and are...

Read the latest Blogs


Tools for DISA's SQL Server STIGs

By aborelli1

Is it possible to request a review of a tool I created to automate...

bcp format file and import fixed width text file

By smattiko83

I'm trying to set up a format file using bcp but I'm unsure of...

insert random value from predefined list of possible values

By marchello

Hi all, My need is to insert random value from predefined list of possible...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Linux Support

See possible answers