We Won't Be Fixing This Database Condition

DZone Database Zone

We Won't Be Fixing This Database Condition

During the work on restoring a backup, the developer in charge came up with the following problematic scenario.

Start restoring the backup of database Northwind on node A, which can take quite some time for a large database. Create a database named Northwind on node B while the restore is taking place.

The problem is that during the restore, the database doesn’t exist in a proper form in the cluster until it is done restoring. During that time, if an administrator is attempting to create a database, it will look like it is working, but it will actually create a new database on all the other nodes and fail on the node where the restore is going on.

more info...