Database Mirroring Using T-SQL
Part three of this series illustrates how to use a T-SQL script to create database mirroring between a principal and mirrored server.
2009-08-20
3,401 reads
Part three of this series illustrates how to use a T-SQL script to create database mirroring between a principal and mirrored server.
2009-08-20
3,401 reads
How to move databases from one server to another with limited downtime
2009-08-17
8,009 reads
2009-07-16
3,044 reads
Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.
2009-07-13
3,451 reads
2009-05-13
2,954 reads
2009-04-08
3,022 reads
2009-03-30
2,993 reads
If you don't have a witness server and your principal server goes, how do you make your mirror server the principal and bring all your databases online?
2009-03-16
2,921 reads
Comparison of performance of SQL 2008 mirroring to SQL 2005 mirroring.
2008-12-10
7,434 reads
One of the configuration options for Database Mirroring is the High Availability mode. With this option three servers are put in place the principal, mirror and witness servers. This is the only option that allows for automatic failover. One of the things that I have noticed is that when there are periodic network issues a failover occurs even though there are no issues with the Principal server. Are there any options to delay the failover?
2008-10-29
3,626 reads
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Comments posted to this topic are about the item The World of Data Science
First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...
Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...