General discussion

Locked

Starting and stopping NT4 services

By andy ·
We have an NT4 server which has the SQL Anywhere server installed. At present we manually stop the service when we leave at the end of the day so the backup (which starts at 10:00pm) can backup the database. It is then restarted in the morning.

How can we start and stop this service automatically? The only sheduler I can find is 'AT' which runs batch files and CMD files, but does not appear to deal with services (or does it?)

What do you suggest?

Thanks in advance

Andy

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Starting and stopping NT4 services

by SyscoKid In reply to Starting and stopping NT4 ...

You could create a batch file to net stop the SQL Anywhere service, and another to start it, and use AT to schedule those batch files.

What do you use for backup? I've heard in Arcserve you can configure it to do this for you.

Collapse -

Starting and stopping NT4 services

by andy In reply to Starting and stopping NT4 ...

The question was auto-closed by TechRepublic

Collapse -

Starting and stopping NT4 services

by Cactus Pete In reply to Starting and stopping NT4 ...

If you want to use AT, the command to stop a service looks like:

NET STOP "Service name"

Starting is just as easy:

NET START "Service name"

Collapse -

Starting and stopping NT4 services

by andy In reply to Starting and stopping NT4 ...

The question was auto-closed by TechRepublic

Collapse -

Starting and stopping NT4 services

by NetTek In reply to Starting and stopping NT4 ...

You can stop and start services from a command line. To find which command to use for the SQL Anywhere service, run regedit and navigate to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
Here you will find folders with the names of all the services of your server. It is the name of the folder that can start or stop a service.
For example
c:\net stop SqlAnywhere
You may use the AT command in conjunction with these command lines.

Also, most third-party backup software has the ability to execute commands when the backup job runs. For example, we use ArcserveIT, and we schedule a batch file that contains simple "NET STOP <Service_name>" commands to run when the backup job starts that will stop certain database applications so that the db can be backed up.

Collapse -

Starting and stopping NT4 services

by andy In reply to Starting and stopping NT4 ...

The question was auto-closed by TechRepublic

Collapse -

Starting and stopping NT4 services

by andy In reply to Starting and stopping NT4 ...

This question was auto closed due to inactivity

Back to Windows Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums