Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Database Mirroring Rss

Search for any content tagged database mirroring

<< Newer    Items 21 to 32 of 32   
 

What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?

Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005? This question was asked on a technical discussion group. My reply follows.  Read more...
By Robert Davis 2009/05/19 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 2,559 reads

Database Mirroring Automating Failover for Multiple SQL Server Databases With No Witness

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?  Read more...
By Additional Articles 2009/03/16 | Source: MSSQLTips.com | Category: database mirroring
Rating:  Rate this |   Briefcase | 2,658 reads

Database Mirroring FAQ: Why is my mirror database in a restoring state?

Question: Why is my mirror database in a restoring state? Hi, I am still working on DB mirroring with prinicpal and mirror. There will be no Witness. This is what I did and   Read more...
By Robert Davis 2009/03/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 11,356 reads

Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?

Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online? This question was sent to me via email. My reply follows. Quick question on DB mirroring client redirection after Principal fails   Read more...
By Robert Davis 2009/02/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,086 reads

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.  Read more...
By Robert Davis 2009/02/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,177 reads

SQL Server 2008 Mirroring Testing

Comparison of performance of SQL 2008 mirroring to SQL 2005 mirroring.  Read more...
By Jason Shadonix 2008/12/10 | Source: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 7,256 reads

Database Mirroring adjusting the automatic failover time

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?  Read more...
By Additional Articles 2008/10/29 | Source: MSSQLTips.com | Category: database mirroring
Rating:  Rate this |   Briefcase | 3,196 reads

Database Mirroring Automating Failover for Multiple Databases

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.   Read more...
By Additional Articles 2008/09/08 | Source: MSSQLTips.com | Category: database mirroring
Rating:  Rate this |   Briefcase | 3,732 reads

Best Practices when performing maintenance in a DBM environment

If you have configured database mirroring in synchronous with or without automatic failover mode, you can switch to the mirror server instance and make it available to the clients while you perform hardware or software maintenance on the principal server instance. So let’s see how we can do this:  Read more...
By Additional Articles 2008/03/27 | Source: SQL Community | Category: database mirroring
Rating:  Rate this |   Briefcase | 1,926 reads

Internals of DBM Failover / Role Switching

Understanding different types of failovers/Role Switching and How do they internally work in database mirroring.  Read more...
By Additional Articles 2008/03/14 | Source: SQL Community | Category: database mirroring
Rating:  Rate this |   Briefcase | 1,167 reads

Getting Started with Database Mirroring

If your database goes offline, you’re probably up a creek, right? If you’re using SQL Server 2005 with SP1, however, the database mirroring feature can prevent disaster.  Read more...
By Additional Articles 2008/02/19 | Source: TechNet Blogs | Category: database mirroring
Rating:  Rate this |   Briefcase | 3,631 reads

A Reporting System Architecture

This article describes one method of implementing a reporting system in SQL Server 2005  Read more...
Rating: |  Discuss |   Briefcase | 12,749 reads
<< Newer    Items 21 to 32 of 32