I'm trying to detach a Nintex 2013 content DB using the following command:
NWAdmin.exe -o DetachDatabase -serverName ContentSQL -databaseName NW_Portals
However I'm receiving the following error:
Server name not specified.
Check operation usage:
NWAdmin.exe -o DetachDatabase -serverName serverName [-databaseName contentDatabase]
Has anyone seen this issue before?
Solved! Go to Solution.
ContentSQL is a SQL alias so shouldn't need a FQDN. I originally attached the DB using the below so not sure what's different about detaching.
NWAdmin.exe -o AttachDatabase -serverName ContentSQL -databaseName NW_Portals -integrated
This might sound odd but did you type the command on the PS window rather than pasting it? I have seen instances where it probably puts in characters and hence the command doesn't recognize itself.
I had a quick look inside the assembly (dotPeek) and the error is put out only when it does not find the server name, the authentication etc comes in later .. so really cant think of anything else other than you could type the command or try to see if it can see any other SQL server?