Browse by Tags

SQL Server Clustering get pre-installation information and choose the best practices for your environment

Published 27 March 8 3:40 AM | SSQA.net

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility...

Filed under: sql server, backup, services, windows, i/o, best practices, cluster, san, raid, setup, hcl, binaries, checklist

Relation between SQL Server 2005 and Volume Shadow Copy services?

Published 19 February 8 2:45 AM | SSQA.net

Until last month I was not aware about Volume Shadow Copy and what is the relation between that service & SQL Server services, so here I would like to give the information in this regard that will discuss SQL Server connection issues that you may...

Filed under: sql server, backup, database, disk, best practices, vss, configuration, volume shadow, sqlwriter

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

SQL Server 2005 Best Practices Analyzer (July 2007) - out from CTP

Published 10 July 7 4:18 AM | SSQA.net

As I have blogged previously that SQL2005BPA is out from CTP now. The BPA for SQL 2005 release in July 2007 is complete package that gathers data from Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations...

Filed under: sql server, backup, best practices, ctp, analyzer, full-text