Tips You should restart SQL Server Agent before launching the instance of SQL Server in single-user mode. Click "View," then "Object Explorer." Right-click "SQL Server Agent" and then click "Stop." ...

To do this, we’ll use an SQL Server Agent Job. Using SQL Management Studio, create a new SQL Server Agent Job: Fill in the general details and then go to the Steps page to add a couple of steps.

Click the name of your SQL server in the Object Explorer pane to expose your databases. Select "user databases," then right-click the name of the database you want to restore (Source 1).

5. Restart sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver and net start msssqlserver.

I'm trying to start/stop MS SQL Service on various DB servers (locally) but we don't always know the name of the instance (Always only 1 SQL Server running on a single server).