Hello. SQL Server 2008 Express and Management Studio.
Ages ago I used to have a shortcut on my desktop, and one at the bottom right corner, that I could click or right-click to start or stop the server. Does anyone know how I can re-instate this?
Andy.
Start/Stop SQL Server
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Start/Stop SQL Server
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Start/Stop SQL Server
SQL Server 2008, unlike SQL Server 2000, doesn't come with a Service Manager. But see SQL Server Service Manager (free).
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Start/Stop SQL Server
Thanks for thisHansV wrote:SQL Server 2008, unlike SQL Server 2000, doesn't come with a Service Manager. But see SQL Server Service Manager (free).
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- 3StarLounger
- Posts: 308
- Joined: 24 Feb 2010, 13:41
Re: Start/Stop SQL Server
Will this work on SQL Server 2008 R2? I couldn't see where it says yes or no.
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Start/Stop SQL Server
I haven't actually installed it, but it states that it will find all available server instances, and list them so they can be started/stopped.kwvh wrote:Will this work on SQL Server 2008 R2? I couldn't see where it says yes or no.
For me, it's slightly more detailed than I need at the moment, as I'm not using SQL Server regularly enough. I might investigate a shortcut/ command line to start and stop, or even (hopefully) toggle the server.. I'm sure this must be possible
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Start/Stop SQL Server
Also see SQL Server on a Netbook – Part 2. Make sure to read the entire article.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Start/Stop SQL Server
That's great, thank youHansV wrote:Also see SQL Server on a Netbook – Part 2. Make sure to read the entire article.
All I need now is a .bat conditional to start if stopped, stop if started . I assume I need to read the current status of a service..
Might need to dip into .vbs if I want a message to confirm the current status..
Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Start/Stop SQL Server
No problem
NET START "SQL Server (SQLEXPRESS)"||NET STOP "SQL Server (SQLEXPRESS)"
I don't need a confirmation as the command prompt confirms whether it's started or stopped. Great, ta, Andy.
Added: Pushed it into my quick launch and changed the title, and the icon, as well
NET START "SQL Server (SQLEXPRESS)"||NET STOP "SQL Server (SQLEXPRESS)"
I don't need a confirmation as the command prompt confirms whether it's started or stopped. Great, ta, Andy.
Added: Pushed it into my quick launch and changed the title, and the icon, as well
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.