Modifying files in Managed Instance might fail with the error 3023

This is a transient error that happens because you executed ALTER DATABASE ADD FILE command while there is some ongoing backup command (for example, backup log that happens every 5min but it is very fast, or differential/full database backup that might be longer operation). The command will succeed if you try it again later.

If you want to check is there some ongoing backup command that is running, you can run the following query:

If you get some result, it means that you will not be able to modify files until the command finishes. On the following picture you can see that the query gives you ETA when the backup will complete:

If you see the result of this query, you will need to wait until ETA to run your command.

Related posts:

Many strange stories are told about things which happen on the sea. Some of these are not true, but one of the strangest is the true story of a ship which was called the Mary Celeste. About a hundred…

Have you ever heard that smell is attached to memory more than any other sense? Probably so, somewhere along the way. My first memory is of the smell of stale oil and dirt. Kind of like in an old…

Recently I attended my first Sydney Scrum User Group meetup — I’d been meaning to go for a while, but you know, life. I have been stalking Zuzi on LinkedIn and her blog for quite some time and am a…