DetachDatabase finds more than one matching database

Userlevel 2

+9

When attempting to detach a Nintex content database using the NWAdmin.exe -o DetachDatabase command, more than one matching database is found.

More than one matching content databases were found. Please specify database name using -databaseName parameter.

Open SQL Management Studio on the database server.
Perform a select query on the 'dbo.Databases' table in the Nintex configuration database.
Compare the database name entries in the table to identify the duplicate entries.
The database name with the highest Database ID is most likely the duplicate database.
Perform a SELECT query on the 'dbo.Storage' table. Make sure the Database ID identified as the duplicate entry is not being used by a Site Collection.
Once the Database Id has been identified, perform the below command.

DELETE FROM database WHERE DatabaseID = <Insert DatabaseID here>

Once the entry is removed from the table, disconnect and remove the database from SQL Management Studio.

Be the first to reply!

Sign up