Browse by Tags

All Tags » sql server » database mirroring (RSS)
SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?
Published 12 May 8 4:25 AM | SSQA.net
Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...
Filed under: , , , , , , , ,
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 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: , , , , , , , ,
FIX: Error message when you start a database mirroring session in SQL Server 2005: "Communications to the remote server instance 'TCP://<ComputerName>:<PortNumber>' failed before database mirroring was fully started"
Published 4 February 8 6:3 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...
Filed under: , , , , , ,
FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server 2005
Published 17 December 7 7:19 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: You must restart the SQL Server service on the principal server after you...
Filed under: , , , , , , ,
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: , , , , , , ,
Installing SQL Server Integration Services on 64-bit Computers
Published 19 November 7 8:29 AM | SSQA.net
I had tough time working with Integration Services (SSIS) on one of the 64 bit machine that will be used for a 24/7 based application. So here goes my ranting and things you need to take care when having installation of SQL Server 2005 on 64 bit platform...
Filed under: , , , , , , , , , ,
Database Mirroring sys.sp_dbmmonitorupdate stored procedure fails with error "Incorrect syntax near '-'"
Published 12 November 7 3:23 AM | SSQA.net
Recently got stuck with the stored procedure sys.sp_dbmmonitorupdate which is used to monitor the database mirroring session. As usual you could do using the GUI tool, but sometimes using TSQL methods is good enough to see what is happening on your system...
Filed under: , , , , , , , , ,
SQL Server 2008 - enhanced feature in database mirroing "log compression"
Published 15 October 7 4:11 AM | SSQA.net
Database Mirroring - new feature from SQL Server 2005 within High Availability ranch, a software based solution for database availability. Very important for the DBAs to keep up the database recovery model to FULL at all the times to achieve the High...
Filed under: , , , , , , ,
Database Mirroring enhancements in SQL Server 2008
Published 4 October 7 9:9 AM | SSQA.net
So far from the CTP release of SQL Server 2008 there has been few enhancements to the Database Mirroring, few of them I would like to list from what has been stated in BOL: Log Performance Enhancements Compression of stream data for which at least a 12...
Filed under: , , , , , ,
FIX: Transactions that are being committed on the principal server may not be copied to the mirror server when a database mirroring failover occurs in SQL Server 2005
Published 26 September 7 3:34 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...
Filed under: , , , , , ,
Database Mirroring: naming resolution issues during failover connectivity
Published 24 September 7 10:13 AM | SSQA.net
Within a Database Mirroring session within an automatic failover situation it may fail with the error : "The server network address "%.*ls" can not be reached or does not exist. Check the network address name and reissue the command"...
Filed under: , , , , , , , ,
FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: "The connection attempted to fail over to a server that does not have a failover partner"
Published 21 September 7 9:53 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...
Filed under: , , , , , ,
FIX: Error message when you run a maintenance plan that contains a Back Up Database task in Microsoft SQL Server 2005 Service Pack 2: "0x80004003: Object reference not set to an instance of an object"
Published 19 September 7 11:58 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...
Filed under: , , , , , ,
SQL Server Database Mirroring error with TCP port numbers, firewall involvement
Published 13 September 7 10:35 AM | SSQA.net
Lately we have been getting complaints that database mirroring setup on few of our client's site were failing with TCP related errors. For more information these sites are involved within the firewall setup and active directory too. Initial workaround...
Filed under: , , , , , , , , ,
FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005
Published 12 September 7 12:46 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Changes in the publisher database are not replicated to the subscribers in a transactional...
Filed under: , , , , , ,
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: , , , , , , ,
How to install service packs and hotfixes on an instance of SQL Server 2005 that is configured to use database mirroring
Published 8 September 7 4:18 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Filed under: , , , ,
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: , , , , , ,
The following KBA pages were recently modified - SQL Server 2005 webcasts
Published 27 August 7 6:17 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Support WebCast: How to use the DataReader...
Filed under: , , , , , , ,
More Posts Next page »