ChangeDatabaseInstance("") not working

Question

When I am executing the below PS script it's throwing the update conflict error :
$db = get-spdatabase -identity
$db.ChangeDatabaseInstance(" ")
$db.Update()
Update error:
An update conflict has occurred, and you must re-try this action. The object SPServer Name=SQLSERVERAG was updated by domain\userid123 in the w3wp (14568) process
What could be the possible reason I could look into.

Nanddeep Nachan · Answer

Please try below 2 options: Restart the OWSTIMER service on ALL of the MOSS servers in the farm Clear SharePoint Configuration cache at folder C:\ProgramData\Microsoft\SharePoint\Config\ \

Raghavendar Swaminathan · Answer

Hi Rahul,   PFB Article which would helps.    https://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=202    https://sharepoint.stackexchange.com/questions/97279/find-a-farms-database-server-and-instance-in-powershell

ChangeDatabaseInstance("<DBServerName>") not working

2 Replies