Browse by Tags
All Tags »
high availability (RSS)
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 these
Read More...
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
Read More...
One of the user has been confused to see lot of .TUF file within their server where the log shipping is enabled. Basically this .tuf file is the T ransaction U ndo F ile, which is created when performing log shipping to a server in Standby mode. So if
Read More...
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
Read More...
One of our client had such requirement to cater a load balancing for their application and needed to upgrade to higher versions of SQL Server & Operating systems. The current setup at their end is a SQL Server 2000 Active/Passive Cluster and the transactions
Read More...
--------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001'
Read More...
SELECT DB_NAME(database_id) AS 'DatabaseName' , mirroring_role_desc , mirroring_safety_level_desc , mirroring_state_desc , mirroring_safety_sequence , mirroring_role_sequence , mirroring_partner_instance , mirroring_witness_name , mirroring_witness_state_desc
Read More...
Have you ever wondered you can recover a corrupted database when you have optimum backup & restore strategy in place, well I'm not talking about usage of third party tools or use high-end hardware. With simple backup and restore features in SQL Server
Read More...