Computing.Net > Forums > Windows 2000 > SQL Service won't stop using NET ST

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

SQL Service won't stop using NET ST

Reply to Message Icon

Name: d27
Date: October 4, 2006 at 08:30:14 Pacific
OS: 2K Server SP4
CPU/Ram: Xeon 1.8GHz
Product: Dell PowerEdge
Comment:

Hi, hope someone can help.
I have a few applications on my 2K server that need MSSQL to run. As I'm only using Windows built-in backup software, I have to turn off the SQL services before the backup starts. I do this by simply running a scheduled task with a .bat file which uses a NET STOP command. 2 of the services stop fine and the backup is OK. The remaining service does not stop. If I run the NET STOP manually, it prompts for an input (are you sure Y/N). The other two just stop. How can I either force the service to stop, or better still, edit the batch to respond with 'y'? Big star for anyone who helps!

Thanks in advance.



Sponsored Link
Ads by Google

Response Number 1
Name: wanderer
Date: October 4, 2006 at 08:55:30 Pacific
Reply:

Sometimes a /y will do it for batch processing or a redirect <y

never tried it on a net stop

Give a person a fish, they eat for a day. Suggest they internet search and they learn a skill for a lifetime.


0

Response Number 2
Name: d27
Date: October 19, 2006 at 07:12:47 Pacific
Reply:

Big star for you!

Thanks, it worked a treat.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows 2000 Forum Home


Sponsored links

Ads by Google


Results for: SQL Service won't stop using NET ST

Dumping won't stop www.computing.net/answers/windows-2000/dumping-wont-stop/39697.html

modem won't shut up www.computing.net/answers/windows-2000/modem-wont-shut-up/36597.html

SQL Server Service MGR-won't start! www.computing.net/answers/windows-2000/sql-server-service-mgrwont-start/53997.html