Browse by Tags

SQLPASS Summit 2008 - Effective Usage of Database Mirroring SQL 2005 & 2008

Published 21 November 8 11:40 AM | SqlServer-QA.net

Its the last day of SQLPASS Summit 2008 and in few hours time I will be presenting my talk (first time in US SQLPASS) on " Effective Usage of SQL Server 2005 Database Mirroring, what's new in SQL 2008 " topic which is an enhanced version...

Filed under: sql server, high availability, best practices, database mirroring, usage, versions

SQL Server 2005 Multi-Site Clustering with Windows Server 2008

Published 2 November 8 10:20 AM | SqlServer-QA.net

I was working recently with a customer who was looking to deploy a SQL Server 2005 cluster across 2 geographically dispersed sites using Windows Server 2008. They were looking to utilise the new clustering improvements in Windows Server 2008 to build...

Filed under: sql server, high availability, 2008, clustering, 2005

SQL Server Web Edition - What is this new edition?

Published 26 September 8 2:27 AM | SqlServer-QA.net

If you remember about editions of SQL Server from 2000 onwards you will see Enterprise, Standard, Personal & Desktop Edition (MSDE) and when it comes to 2005 version Enterprise, Standard, Workgroup, Express & Express Advanced Services. So what's...

Filed under: sql server, high availability, web, data mining, intelligence, reporting services, business intelligence, integration services, data warehouse, scalability, editions

Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy - Tech-ed Online Panel video available to view

Published 22 July 8 6:37 AM | SSQA.net

In continuation to Tech-ed North America - what I'm doing there? & Say goodbye to Tech-ed 2008 Developers and say hello to IT-PRO! posts here and to wrap up the earlier posts about Tech-ed Online Panel: Leveraging SQL Server Technologies to Build...

Filed under: sql server, high availability, tech-ed, online, strategy, networking, panel discussions, standards

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: business continuity, sql server, high availability, version, 2008, best practice

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: sql server, microsoft, high availability, tech-ed, dba, conference, networking, tlc, indexing, panel discussions, dat

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, high availability, tech-ed, 2008, 2005, online, panel, discussion

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

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: business continuity, sql server, high availability, technet, security, 2008, trusted platform, data loss, data platform

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

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, restore, high availability, backup, olap, dimension, cube, rolap, molap, holap, storage mode

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: sql server, databases, high availability, database mirroring, tsql, best practice, production, testing

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, restore, high availability, backup, disk, recovery, san, best practice, hardware

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: sql server, microsoft, high availability, download, 2008, ctp, new, 2005, available, new features, many more

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

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: sql server, high availability, transaction log, log file, log shipping, files, .tuf

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

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: sql server, high availability, server, login, cluster, log shipping, service account, firewall, unable, filecopy