Browse by Tags

All Tags » sql server » high availability (RSS)
Achieving 99.99% Business Continuity with SQL Server tools
Published 6 June 8 2:39 AM | SSQA.net
Within the IT organisations it has been a huge expansion of increased challenges with regard to number of office locations and keep up the data consistent across the Enterprise. Travelling around the globe is a olden day myth and now even by sitting at...
Filed under: , , , , ,
Tech-ed North America - what I'm doing there?
Published 29 May 8 4:18 PM | SSQA.net
This is first time Microsoft has divided the conference into 2 sections, Developer & IT-PRO. Why Attend Tech-ed? IT Pros, you'll gain new solutions and new ideas for being more productive from sessions, product assessments, and interaction with...
Filed under: , , , , , , , , , ,
Tech-ed Online Panel: Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy
Published 29 May 8 4:11 AM | SSQA.net
Are you visiting Tech-ed, North America? Tech·Ed offers the premier technical education conference just for IT professionals. Microsoft and industry experts will share their expertise about how to architect, deploy, manage, and help secure a connected...
Filed under: , , , , , , ,
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 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: , , , , , ,
Webcast: 24 Hours of SQL Server 2008: Ensuring Your Data Is Secure with a Trusted Platform
Published 28 March 8 6:45 PM | SSQA.net
Another part of Technet webcast series on SQL Server 2008. In this part a focus on IT professionals and the SQL Server 2008 the Trusted Platform. In the first part of the series we spent time looking at how Contoso was using SQL Server 2008 as a productivity...
Filed under: , , , , , , , ,
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 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: , , , , , , , ,
Backup and Restore of Analysis Services Database - gotchas
Published 12 December 7 3:38 AM | SSQA.net
Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure...
Filed under: , , , , , , , , , ,
SQL Server 2005 Database Mirroring - basics and related resources
Published 10 December 7 4:33 AM | SSQA.net
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"...
Filed under: , , , , , , ,
Improving Backup and Recovery RTO RPO in a SAN - think on your SQL Server environment
Published 6 December 7 12:47 PM | SSQA.net
Backup and restore practices are at the core of today's best business continuity plans. While backup and restore provides many benefits, it simultaneously presents a variety of challenges with lost data, the time it takes to restore data, and the...
Filed under: , , , , , , , ,
SQL Server 2008 - what's new, a list would be nice?
Published 4 December 7 4:48 AM | SSQA.net
SQL Server 2008 Community Technology Preview (CTP) instalment 5 is ready to available for the users, I think this is the 3rd instalment since SQL 2008 is announced by Microsoft. The Application support team have been asking for a list of new/enhanced...
Filed under: , , , , , , , , , ,
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: , , , , , , , , , , , , ,
What is the significance of .TUF file in Log shipping?
Published 12 November 7 12:55 PM | SSQA.net
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...
Filed under: , , , , , ,
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: , , , , , ,
Log Shipping error "Unable to copy the initialization file"
Published 3 October 7 6:49 AM | SSQA.net
When configuring log shipping on a highly transactional environment (with SQL Clustering setup), we were hit by above error. All the Logins and their privileges are intact within the primary and standby servers along with Local server policies & group...
Filed under: , , , , , , , , ,
What should I choose Load Balancing or Data Partitioning?
Published 12 September 7 5:42 AM | SSQA.net
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...
Filed under: , , , , , ,
Other blogs we recommend
Published 12 September 7 5:22 AM | SSQA.net
Today I have started a new section here "Other Blogs we recommend" to roll the blog posts from SQL Server Experts such as Kalen Delaney, Kimberley Tripp, Bob Beauchemin and Paul Randall that I follow regularly. Until now I used to blog roll...
Filed under: , , , , , , ,
Database Mirroring: Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
Published 12 September 7 4:56 AM | SSQA.net
The above error is quite common within the database mirroring setup, you could get to see. The intial workaround for this error will be to check whether any network issues are causing this error when the failover is intiated from a Primary server to the...
Filed under: , , , , , , ,
Whats the best way to setup memory on a four-node cluster?
Published 6 September 7 4:42 AM | SSQA.net
Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances...
Filed under: , , , , , , , , ,
More Posts Next page »