How to Update Database Mapping for a site

[#1]

Topic

How to update a database mapping to a site

Instructions

1. First retrieve the Site ID for affect Site, you can use the following Powershell command to retrieve the SiteID by URL, replacing XXX.AAA with the URL to the site.

 

Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue

$webURL = "HTTP://XXX.AAAA"

$web = Get-SPWeb -Identity $webURL
 

$web.ID 

 

2. Then run the following SQL query on the Nintex Config DB:

select DB .DatabaseID, DatabaseName, SiteID, ServerName from Databases DB

right join Storage ST on st. DatabaseID = db. DatabaseID
 

3. This will retrieve all the sites that are mapped to a Nintex Content DB, make a note of the correct Database ID that site should be mapped to.

 

4 .Finally run the following Stored procedure on the Nintex Config DB, replacing with the DatabaseID (AAA) with the one found in the previous step, and the SiteID (BBB) with the one found in the first step.
 

EXEC @return_value = [dbo].[UpdateStorage]
@DatabaseId = AAA,
@SiteId = BBB

5. Then run the SQL query from step 2 again, to verify that the site is now mapped to the correct Nintex Content DB.