Paaki
asked on
SQL 2005 Services instance status stuck up
I am testing moving system database to new drive since my production has these database movement planned for weekend.
While trying to change start up parameters to move master database the SQL SERVER <OFFICESERVER> status is stuck up at "starting" and could not start or restart..
When checked in SSCM the status shows change pending"..So I tried reconfiguring my start up parameters and reverted back to paarmeters:
-dC:\Program Files (x86)\Microsoft Office Servers\12.0\Data\MSSQL.1\ MSSQL\DATA \master.md f;-eC:\Pro gram Files (x86)\Microsoft Office Servers\12.0\Data\MSSQL.1\ MSSQL\LOG\ ERRORLOG;- lC:\Progra m Files (x86)\Microsoft Office Servers\12.0\Data\MSSQL.1\ MSSQL\DATA \mastlog.l df
My SLQ instance shown in services.msc is :
service name MSSQL$OFFICESERVERS
Excutable path :
"C:\Program Files (x86)\Microsoft SQL Server\MSSQL.5\MSSQL\Binn\ sqlservr.e xe"
While trying to change start up parameters to move master database the SQL SERVER <OFFICESERVER> status is stuck up at "starting" and could not start or restart..
When checked in SSCM the status shows change pending"..So I tried reconfiguring my start up parameters and reverted back to paarmeters:
-dC:\Program Files (x86)\Microsoft Office Servers\12.0\Data\MSSQL.1\
My SLQ instance shown in services.msc is :
service name MSSQL$OFFICESERVERS
Excutable path :
"C:\Program Files (x86)\Microsoft SQL Server\MSSQL.5\MSSQL\Binn\
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.