Overview
In previous articles I wrote about how you check that Instant File Initialization (IFI) is set, and how to set it. At the time, it was not available for the Log file. This has now changed.
Continue readingIn previous articles I wrote about how you check that Instant File Initialization (IFI) is set, and how to set it. At the time, it was not available for the Log file. This has now changed.
Continue readingIn a previous article I demonstrated how to use a Distributed Availability Group (DAG) to move an Availability Group (AG) from one domain to another.
Of course, there are things to watch out for.
Continue readingOver the past year I have been working on a project to migrate a 4-node AG with multi-terabyte databases, to another AG in a Cloud environment. To add to the fun, the downtime had to be kept to an absolute minimum.
Continue readingFor a future article, I require a Listener for the Availability Group (AG) that was created from this article.
This post describes the simple steps required to create a Listener.
Continue readingAs part of a series of development actions, we need to replace our SQL Server 2012 installations with SQL Server 2017. This is a four-node Availability Group (AG) for a system that is required 24/7 – so downtime is best avoided.
Continue readingWhen upgrading a SQL Server installation to SQL2017, SQL Server Reporting Services (SSRS) is now a stand-alone installation. This short article lists the main issues that we encountered, as best as I can recall.
Continue readingFor some investigative work that I had to do, I required an Availability Group (AG) that I could destroy and rebuild without impacting anybody else. Hyper-V was an obvious solution and this article describes the steps required.
Continue readingWhen attempting to back up the key, within Reporting Services Configuration Manager, it fails and provides a less than helpful error message.
Continue readingWhilst watching a Pluralsight training course by Paul Randal, on ‘Logging, Recovery and the Transaction log’, a particular snippet related to differential backups piqued my curiosity.
Basically, does a differential backup only take backups of altered pages, within a database.
The short answer is ‘yes’, but the detail is a little bit more interesting than that.
Continue readingI needed a process that could copy the contents of a specific list of tables, from one database to another. PowerShell seemed to be the best fit, for my purposes. As with any tool that you don’t use regularly, more than half of the battle is finding the correct commands and methodology.
Continue reading