General discussion

  • Creator
    Topic
  • #2091365

    Remotely stop/start NT services

    Locked

    by oliver.buckie ·

    I wish to schedule a backup an SQL 7 database from another PC. I need to stop some of the SQL services (mssqlserver & sqlexecutive), then backup the databases and then re-start the services. How can I do this from another NT system running the backup device?

    At the moment I use the NT Task Schedular to run a batch file (cmd) which in turn runs NT Server Backup. I just need the commmand for for remotely stopping/starting services.

    Thanks for any help

All Comments

  • Author
    Replies
    • #3880167

      Remotely stop/start NT services

      by dc1 ·

      In reply to Remotely stop/start NT services

      Use Server Manager. Highlight the server name and from the menu choose Computer and then services. As long as you have the necessary rights to stop and start services you will be able to do so.

    • #3880157

      Remotely stop/start NT services

      by simonchan ·

      In reply to Remotely stop/start NT services

      Windows NT Server 4.0 Resource Kit Supplement 1, comes with two new administrative utilities to work remotely with Windows NT services.

      The new utilities are:

      Sc.exe: This tool provides a way to communicate with Service Controller (Services.exe) from the command prompt, to retrieve information about services.

      Netsvc.exe: This tool provides a way to remotely start, stop, and query the status of services from the command line.

      Please consult the Windows NT Server 4.0 Resource Kit, Supplement 1, for additional information on the syntax and use of Sc.exe and Netsvc.exe.

    • #3879754

      Remotely stop/start NT services

      by allan ·

      In reply to Remotely stop/start NT services

      If you have an idea how long the backup takes you can use the “AT” command and run a bat file . This bat file would be net stop \\server\service. Again use the AT command to run a second bat file for net start \\server\service after the backup completes.

      • #3866623

        Remotely stop/start NT services

        by oliver.buckie ·

        In reply to Remotely stop/start NT services

        I have this solution in place at the moment – in fact I use the Task Scheduler service which comes off one of the resource kits

    • #3880515

      Remotely stop/start NT services

      by mteff ·

      In reply to Remotely stop/start NT services

      Just as a suggestion, why not through SQL Server manager, use the Database backup ability. It writes the database out as a file, that you can backup to tape.

      In SQL Server Manager, under the Database Folder, right click on your database, select all tasks, then backup database. For the destination, you will need to give location and file name.

    • #3866620

      Remotely stop/start NT services

      by oliver.buckie ·

      In reply to Remotely stop/start NT services

      This question was closed by the author

Viewing 4 reply threads