How to move Cluster Quorum Drive
I recently had the need to move the quorum for a cluster to a new SAN drive. It’s a quite simple...
2011-07-25
1,491 reads
I recently had the need to move the quorum for a cluster to a new SAN drive. It’s a quite simple...
2011-07-25
1,491 reads
Note that TempDB is recreated every time SQL starts. Why is this important? It means we don’t have to move the...
2011-07-14
738 reads
First we need to know the name and file location of the MSDB database files. When you change the location, make...
2011-07-13
941 reads
First we need to know the name and file location of the Model database files. When you change the location, make...
2011-07-12
5,637 reads
The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the...
2011-07-11
1,300 reads
You cannot add a connection to your CMS server, on your CMS server. Well that is what I thought until...
2011-07-06
1,271 reads
This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”. My favorite DR solution is...
2011-06-14
694 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers