September 30, 2014 at 6:24 am
Facing a issue while trying to rebuild the master DB, any help and suggestion appreciated.
SQL Server version : 2008
Cmd am using :
/QUIET /ACTION=REBUILDDATABASE /INSTANCENAME='sqlserver\Autotest' /SQLSYSADMINACCOUNTS='Domain\administrator' /SAPWD='Test@123'
Note : Tried with but setup file from boot strap and installation media
Below is the error message am getting:
Exception type: System.Xml.XPath.XPathException
The following error occurred:
'//Machine/Product[@ID='SQL2008']/Instance[@ID=''sqlserver\Autotest'']/Feature[not(@ClusterName='')]' has an invalid token.
September 30, 2014 at 8:44 am
Just the instance name is required not the full servername
/QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=Autotest
/SQLSYSADMINACCOUNTS='Domain\administrator' /SAPWD='Test@123'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2014 at 5:30 am
Thanks for the responce Perry!!
I was able to fix it not only by by using instance name without full servername and we need to pass the
sysaccount details in double quote instead of single.
/QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=Autotest
/SQLSYSADMINACCOUNTS="Domain\administrator" /SAPWD='Test@123'
October 1, 2014 at 5:31 am
great, thanks for replying as this may help others in the future 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply