You are here: Saotn.org » Archives for October 2018

October 2018

Manually failover all databases in an SQL Server Database Mirroring configuration

How to manually failover an SQL Server database mirroring session?

How to manual failover mirrored SQL Server databases using Transact-SQL (T-SQL) in SQL Server 2017+. This can only be initiated from the principal server, and the mirrored database must be synchronized (that is, when the database is in the SYNCHRONIZED state). In this article I’ll show you how to force a failover.

Read More »Manually failover all databases in an SQL Server Database Mirroring configuration

ASP and ASP.NET connection string examples for Microsoft SQL Server and MySQL

A connection string is sometimes a bit obscure. Do I need ODBC or OLE DB? When you need one and Google for it, you often find old ones that either don’t work at all anymore, or are not optimal. This article provides you with a couple of ASP.NET to SQL Server connection string examples, and as a bonus for ASP to MySQL too.

Read More »ASP and ASP.NET connection string examples for Microsoft SQL Server and MySQL