To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed. – when moving files on an Availability Group secondary.

Here's a little error that I stumbled across the other day when trying to migrate the data files of an Availability Group secondary node onto a nice new SAN. I started off by running the following command against the secondary server. ALTER DATABASE SQLUndercover MODIFY FILE (NAME = 'AG01', FILENAME = 'E:\DATA\AG01.mdf') There's nothing wrong... Continue Reading →

Jun 6, 2019 0

Filling Missing ID Codes In SQL

This is going to be a bit of a brain storming post that comes from an interesting question that I was asked today... "I've got a table with a ID code field, now some of the rows have a value in that field and some are NULL. How can I go about filling in those... Continue Reading →

Mar 26, 2019 1

Up ↑

Category: SQL Server

To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed. – when moving files on an Availability Group secondary.

Filling Missing ID Codes In SQL

David Fowler

Adrian Buckman

Archives

Follow me on Twitter

Recent Posts From The Undercover DBAs