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 of what I have presented before in SQLBIts UK during September 2007. Just a highlights on the ...

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 is an advantage to avoid the costs and pre-requisite for Clustering, as it comes ...

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 default you can see a failover cluster as a combination of one or more nodes (servers) with two or ...

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 that might crop up in this case. Also you should be cautious when you have reporting ...

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 must be started using a domain account (normally) so as to have access on both the Principal ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise EditionNotification Contents: New and All Modifications FIX: Error message when you start a database mirroring session in SQL Server 2005: ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New and Major Modifications 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 ...

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'' configuration within the SQL Server 2005 that allows a database to be highly available ...

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, specially within ETL processes completion. So at first, when you install SQL Server ...

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.   On the system with SQL 2005 Service pack2 when executing this ...