Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook

When we talk about availability the key step in providing the feature is to ensure such feature is available and easily implemented. High Availability is purely dependant on hardware and software that will activate the failover or failback whenever the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jan 9 2012
Filed under: Filed under: sql server, performance, high availability, database mirroring, key, solution accelerator, cookbook, #sql2k8r2cookbook
Checking DB Mirroring Status

Often I see a question in community on how to quickly check the status of the database mirroring, sometime in busy environment and busy server launching database mirroring keep us waiting for a while, so is there a way we can check database mirroring...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Tue, Sep 13 2011
Filed under: Filed under: sql 2005, High Availability, sql 2008, database mirroring, Book on SQL Server 2008, mirroring status
Winner of the contest

Dear Readers, I am very please to announce winner of the contest about describing best HA & DR solution. The contest was successful, there are about 5 entries I have get from various sources like linkedin and email, I would like to thank all the participant...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Thu, May 5 2011
Filed under: Filed under: Replication, Log Shipping, Clustering, High Availability, SQL Server MVP, database mirroring, Book on SQL Server 2008, cluster resources, packt publication
Describe HA and DR strategy and win

Dear Readers, I am very please to made an announcement about the contest. As you aware that I have wrote a book on SQL Server 2008 High Availability which was published on 24th January 2008 by Packt Publication . Now you have a chance to win a subscription...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Sun, Mar 6 2011
Filed under: Filed under: Replication, Log Shipping, Clustering, High Availability, Sql server 2008, SQL Server MVP, database mirroring, Book on SQL Server 2008, database administration, cluster resources
The SQL Server Service Broker or Database Mirroring transport is disabled or not configured

In the recent times the alert 'The SQL Server Service Broker or Database Mirroring transport is disabled or not configured' has been reported by monitoring software. The initial thoughts were to check SQL Server error log for any database mirroring...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Feb 8 2011
Filed under: Filed under: sql server, high availability, dba, best practices, service broker, database mirroring, endpoint, partner, enabled
SQL Server 2008 High Availability – A Book

I have no words to explain my excitement and happiness to share news with you all - my book on SQL Server 2008 High Availability is published!! I have started authoring this book in May 2010 and as the time passes and gradually I move to the final chapter...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Tue, Jan 25 2011
Filed under: Filed under: Replication, Log Shipping, Clustering, Sql server 2008, database mirroring, sql server high availability, Hemantgiri S. Goswami, sql server citation, Book on SQL Server 2008
Database Mirroring issues: Error: 1418: he server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

Database Mirroring setup is quite easy between the SQL Server instances when you don't have any pre-configured setup on network or service accounts. But there are certain pre-requisites that you need to be sure about database mirroring setup and resolve...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jul 14 2010
Filed under: Filed under: sql server, database mirroring, error log, authentication, monitoring, kerberos, endpoint, spn, error 1418
SQL Server HA: Quick view of Database Mirroring session between partners

From SQL Server 2005 version onwards database mirroring has been a good resource to provide High Availablity for the systems without having special hardware requirement. While I was assisting at the SME lounge within Database Platform area in Tech-Ed...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 17 2010
Filed under: Filed under: sql server, performance, dba, database mirroring, instances, monitoring, endpoint, troubleshooting
Cumulative Update Package 10 for SQL Server 2008 - have a look at list of bug fixes

In the recent times Microsoft Release Services adopted the 935897 Incremental Servicing Model (ISM) for SQL Server team to deliver hotfixes for reported problems, also the new 822499 naming schema for Microsoft SQL Server software update packages. In...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Mar 17 2010
Filed under: Filed under: sql server, package, kba, database mirroring, build, service pack, best practice, cumulative update
SQL Server High Availability Options Preview

As it is named, all the SQL Servers and databases should be highly available ( HA ) to cater the business requirement, and, the business application should be up and running all the time. To achieve this Microsoft has introduced SQL Server Cluster which...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Sun, Nov 8 2009
Filed under: Filed under: Replication, database mirroring, sqlserverpedia, sql cluster, peer- peer replication, sql server ha, sql server high availability, merge replication, snapshot replication, transaction replication
Community launched | Surat SQL Server User Group | DotNetChaps

Hi, We have formed a Technical Community User Group. The aim of this User Group is to share/exchange what all we have in terms of the knowledge. We have two separate forums for MS SQL and for Dot Net technology to avoid confusion. You may post all your...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Mon, Mar 9 2009
Filed under: Filed under: sql server, sql 2005, Replication, Log Shipping, MS Sql server, ssis, sql server 2000, sql server cluster, sql 2008, DotNetChaps, database mirroring, Surat SQL Server User Group, Community launched
Replication and Database Mirroring - things to take care and best practices to administer the environment

Replication and Database Mirroring are the ones which can provide high availability option without an extra cost what it implies on a Clustering setup. So in this scenario Database mirroring can be used in conjunction with replication to provide availability...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Dec 15 2008
Filed under: Filed under: sql server, high availability, replication, monitor, maintenance, database mirroring, publisher, failover, subscriptions, setup
SQLPASS Summit 2008 - Effective Usage of Database Mirroring SQL 2005 & 2008

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Nov 21 2008
Filed under: Filed under: sql server, high availability, best practices, database mirroring, usage, versions
Publicado White Paper de Database Mirroring en SQL Server 2005

Hola, menuda alegría me he llevado: me han publicado un WP de Database Mirroring la gente de DELL en colaboración con la revista Window ITPro (los editores de SQL Magazine). Esta es la introducción al WP: "Databases hold the vital information that users need to do their jobs and that applications...

Posted to Eladio Rincón y SQL Server by Eladio on Fri, Jul 4 2008
Filed under: Filed under: Whitepaper, SQL Server 2005, Database Mirroring
SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?

Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, May 12 2008
Filed under: Filed under: sql server, databases, best practices, database mirroring, 2005, principal, witness, mirror, timeout
SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, May 8 2008
Filed under: Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability
Database Mirroring, inicios de sesión de SQL, y el procedimiento almacenado sp_change_users_login

Introducción En instalaciones que implementéis database mirroring, debéis realizar tareas de administración para cuestiones que se salen del ámbito de la base de datos; por ejemplo: ¿qué haces con los planes de mantenimiento como reindexaciones, copias de seguridad, etc.? Sabes que todo esto está fuera...

Posted to Eladio Rincón y SQL Server by Eladio on Fri, Apr 25 2008
Filed under: Filed under: SQL Server 2005, Database Mirroring, seguridad SQL Server
SQL Server Database Mirroring and Sharepoint server - gotchas and problem solutions

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Mar 18 2008
Filed under: Filed under: sql server, high availability, technet, database, best practices, sharepoint, database mirroring, failover, links
Setting up Database Mirroring using Local Account

We had a need to setup Database Mirroring for a Disaster Recovery Project. We were at time running SQL 2005 Std SP1. i had to start the SQL Server Service with the startup parameter -T1400 to enable Mirroring. For DB Mirriring to work the SQL Server Service...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Mar 10 2008
Filed under: Filed under: high availability, disaster recovery, database mirroring, failover
FIX: Error message when you start a database mirroring session in SQL Server 2005: "Communications to the remote server instance 'TCP://<ComputerName>:<PortNumber>' failed before database mirroring was fully started"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Feb 4 2008
Filed under: Filed under: sql server, services, kba, database mirroring, failover, endpoint, port

Page 1 of 3 (45 items) 1 2 3 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.