Browse by Tags

SQLPASS Summit 2008 - Effective Usage of Database Mirroring SQL 2005 & 2008

Published 21 November 8 11:40 AM | SqlServer-QA.net

Its the last day of SQLPASS Summit 2008 and in few hours time I will be presenting my talk (first time in US SQLPASS) on " Effective Usage of SQL Server 2005 Database Mirroring, what's new in SQL 2008 " topic which is an enhanced version...

Filed under: sql server, high availability, best practices, database mirroring, usage, versions

SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?

Published 8 May 8 3:42 AM | SSQA.net

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...

Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability

SQL Server Database Mirroring and Sharepoint server - gotchas and problem solutions

Published 18 March 8 6:23 AM | SSQA.net

You may be aware that Database Mirroring is an important High Availability [HA] option available within SQL Server 2005 version. Having this HA option within your Sharepoint farm where the databases are associated to failover, then you must note few issues...

Filed under: sql server, high availability, technet, database, best practices, sharepoint, database mirroring, failover, links

Setting up Database Mirroring using Local Account

Published 10 March 8 5:43 AM | SSQA.net

We had a need to setup Database Mirroring for a Disaster Recovery Project. We were at time running SQL 2005 Std SP1. i had to start the SQL Server Service with the startup parameter -T1400 to enable Mirroring. For DB Mirriring to work the SQL Server Service...

Filed under: high availability, disaster recovery, database mirroring, failover

SQL Server 2005 Database Mirroring - basics and related resources

Published 10 December 7 4:33 AM | SSQA.net

To provide High Availability feature within your database environment you could take advantage of Database Mirroring when using SQL Server 2005. As with all critical databases, minimizing data loss and downtime are of the highest importance. Having "AlwaysOn"...

Filed under: sql server, databases, high availability, database mirroring, tsql, best practice, production, testing

Database Mirroring: Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

Published 12 September 7 4:56 AM | SSQA.net

The above error is quite common within the database mirroring setup, you could get to see. The intial workaround for this error will be to check whether any network issues are causing this error when the failover is intiated from a Primary server to the...

Filed under: sql server, high availability, security, error, database mirroring, service account, 1418, ports

Number of databases limit for Database Mirroring within X64 environment?

Published 30 August 7 5:27 AM | SSQA.net

We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server...

Filed under: sql server, performance, high availability, server, database mirroring, x64, geographic

Get basic Database Mirroring information- principal or mirror

Published 19 August 7 5:32 PM | SSQA.net

SELECT DB_NAME(database_id) AS 'DatabaseName' , mirroring_role_desc , mirroring_safety_level_desc , mirroring_state_desc , mirroring_safety_sequence , mirroring_role_sequence , mirroring_partner_instance , mirroring_witness_name , mirroring_witness_state_desc...

Filed under: sql server, high availability, database, database mirroring, tsql, principal, witness, mirror

Database Mirroring: FQDNs are Your Friends!

Published 16 June 7 2:29 PM | SSQA.net

Cross posted from : Adam Machanic SQLBlog that helped me to resolve one issue during a DB mIrroring issue. Read More...

Filed under: high availability, backup, blog, fqdn, database mirroring