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.mdf;-eC:\Program Files (x86)\Microsoft Office Servers\12.0\Data\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files (x86)\Microsoft Office Servers\12.0\Data\MSSQL.1\MSSQL\DATA\mastlog.ldf
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.exe"
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.