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 , otherwise you may not be able to utilize...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
03-27-2008
Filed under: sql server, backup, services, windows, i/o, best practices, cluster, san, raid, setup, hcl, binaries, checklist
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 encounter when you use Volume Shadow Copy Service...
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 the reasons). But one thing is sure that SQL Server...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
11-16-2007
Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins
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 take care of data which is a prime task for every...
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 and best practices to determine if there...
When you build a house in California, you pour a concrete slab and then build from there. When you install a SBS 2003 system you install it on a server. The foundation. The slab. And as long as your foundation is good and solid, you are good to go as well. On my HP at the office is the HPSmartStart software...