Browse by Tags

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 Release Services - Cumulative Update or frequent Service pack releases, which one you favour?

Published 7 May 8 3:26 AM | SSQA.net

Here is the hot news, SQL Server Global Release Services (GRS) has revised their schedule of releasing Service Packs for SQL Server product by stating ' changed approach to Service Packs '. Now the big question how far you can stretch in deploying...

Filed under: sql server, microsoft, high availability, best practices, service pack, cumulative update, releases

Web Seminar: True High Availability for SQL Servers

Published 27 March 8 4:27 AM | SSQA.net

Another sponsored link I have got from Windows magazine: When: Thursday March 27, 2008 12:00 PM EDT Register today! (now) Simply put, your critical applications use SQL. It is the silent engine behind the curtains doing the heavy and important work keeping...

Filed under: sql server, webcast, high availability, best practices, seminar, applications, HA, helpful

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

Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

Published 16 November 7 4:53 AM | SSQA.net

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...

Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins

How to find whether backup is performed using SQL native methods or third party tools?

Published 23 October 7 4:59 AM | SSQA.net

Interesting question: how can we know the difference between a native backup and backup taken by third party tool? Say you have started newly in a enterprise wide platform and your task is to find out what methods of BACKUP and RESTORE are followed to...

Filed under: sql server, restore, high availability, backup, dba, best practices, third party