Backup databases in an Availability Group
Use this script to backup databases based on their role in an availability group
2017-01-12 (first published: 2017-01-07)
583 reads
Use this script to backup databases based on their role in an availability group
2017-01-12 (first published: 2017-01-07)
583 reads
How many SQL Server instances are you running? Do you ever have customers calling you stating that their application is not working, then when you research the problem you find that the instance that supports their application is unavailable? Have you ever had someone mistakenly shutdown the SQL Agent service and forget to restart it, causing a number of scheduled jobs to not be run? One of the tasks of a DBA is to monitor the availability of all SQL Server instances and services.
2006-08-10
3,195 reads
Are you thinking about consolidating your SQL Servers on to fewer machines? It is an interesting idea and one that is definitely more possible with SQL Server 2005 and 64-bit servers. Steve Jones takes a look at some of the pros and cons of moving to fewer servers.
2006-03-15
7,478 reads
Active/Passive SQL Server 2000 clustering gives more reliability and fault tolerance to Production SQL Server environments. When a failure occurs, all of the resources fail over from the active node to the passive node and make the passive node active. This article explains how to rebuild the node that failed and attach it back to the cluster.
2005-02-10
2,232 reads
Continuing with our worst practices series, Steve Jones looks at another administrative no-no. Making a change to your live system on the fly.
2003-01-20
7,760 reads
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
By Arun Sirpal
I speak to many people who use cloud technologies, especially database tech and how...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers