Midlands Technology Centre, Broadlands, Wolverhampton Business Park, WV10 6TA
0845 241 6370 info@msvconsultancy.co.uk
Enable, Entrust & Educate Through IT

Tag Archives: SQL 2008R2

How to configure SQL Mirroring

There are 3 different types of SQL Mirroring options available for use:
  • High Performance - Asynchronous (this requires the Enterprise Edition)
  • High Safety without Automatic Failover
  • High Safety with Automatic Failover (this requires a witness server running the same SQL version)
All three require roughly the same steps:
  • Ensure the same login accounts are present on the Principal and the...
Read more

Drop All Connections to a SQL Database

I was doing some repairs to a SQL database recently and needed it in single user mode which was the easy part.......... USE master; GO ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO The issue was then as soon as I went to do...
Read more

SQL – Check your authentication scheme

Have you ever wanted to check which method you are using to authenticate to a SQL backend?   Just run the following SQL to return the current authentication scheme your user context is using. SELECT session_id, auth_scheme FROM sys.dm_exec_connections WHERE session_id=@@spid You can easily modify the above to give you the authentication...
Read more