Jump to content

Recommended Posts

Posted
Yes, netsvc seems to do what I want, thanks - any offers where I can download it from? If I ever had a Win2K Resource CD, I've long since lost it...
Posted

you can use computer management I would of thought to do that - right click my computer ( provided you are logged in as domain admin ) and go to manage and then the services section.

 

To do this on a remote machine , just right click where it says this computer in side of manage my computer and click on connect to.

 

Then navigate through there services and restart or stop or w/e

 

If you need a vbscript to do it, look at this :

 

http://www.computerperformance.co.uk/vbscript/wmi_services.htm

 

If that does not work then you may need a bit more in the script to provide admin credentials ( If so post back )

Posted
The next trick is whether it is possible to stop all SQL services in one go, or whether I have to stop each one individually. Any offers?
Posted
The next trick is whether it is possible to stop all SQL services in one go, or whether I have to stop each one individually. Any offers?

 

Unless there are depencies (i.e. lots of services depending on one service) then probably not.

Posted

Start > Run > MMC > Add Snap-in > Services > Specify Workstation

 

This works with any 2000/XP/2003 workstation/server. I'm reluctant to say Vista as MS appear to have changed everything!

Posted

Michael,

 

That does work, and with Vista too!, but I was after an automated way of doing this.

 

I'm looking to stop various SQL services ahead of the backup and restart them afterwards - obviously this is easy enough with scheduled tasks, but I wanted the neatness of having them in one place and also the time-efficiency of only having them stopped for as short a time as necessary.

Posted

PsTools are awesome :) Just had a little play with them, very nice.

 

It says you should put the files in the "Executable path", is that the win32 dir?

Posted
PsTools are awesome :) Just had a little play with them, very nice.

 

It says you should put the files in the "Executable path", is that the win32 dir?

 

I just put them on a share on the network and run them from a UNC path, which worked fine.

  • 2 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...