Stop windows service copy data and then start service

Discussion in 'Scripting' started by Masti, May 11, 2009.

  1. Masti

    Masti Guest

    Hi,
    I need a vbscript which can stop a windows service and copy data and once
    the data is copied over restart the service. This has be done from remote
    server and for multiple servers.

    Any help is appreciated.
     
    Masti, May 11, 2009
    #1
    1. Advertisements

  2. The easiest way to achieve this is by using a batch file:
    @echo off
    sc \\SomeServer stop SomeService
    robocopy /s SourceDir TargetDir
    sc \\SomeServer start SomeService

    If you must use a VB Script then you can use the Run method in order to
    execute the two sc.exe commands.
     
    Pegasus [MVP], May 11, 2009
    #2
    1. Advertisements

  3. Masti

    Masti Guest

    Hi,

    Reason why i asked for vbcript is i need to schedule this task and leave it
    so it runs every weekend. Can you provide me with compelte script?

    Thanks
     
    Masti, May 12, 2009
    #3
  4. Masti

    Al Dunbar Guest

    You don't need vbscript to do that, as you can schedule batch files.

    /Al
     
    Al Dunbar, May 12, 2009
    #4
  5. Masti

    Masti Guest

    Hi,

    can you tell me what is the run method, actually this is what i am planning
    to do .
    we are using netbackup to backup UDDI files. but as some of the files are in
    open state most of the time the backup software was not able to backup open
    files.we dont have an open file agent license . so i need a script Do the
    following:

    Stop the service MSSQL$UDDI
    Copy the folder C:\Inetpub\uddi to a backup location
    Restart MSSQL$UDDI

    Please provide me a script

    any help appreciated , thank you .

    Masti
     
    Masti, May 15, 2009
    #5
  6. Download the help file "script56.chm" from the Microsoft site, then check
    what it says about the "run" method.
     
    Pegasus [MVP], May 15, 2009
    #6
  7. Masti

    Masti Guest

    Hi,
    I tried the script you provided but it failed to stop the service and copy
    files and start service.

    here is the script i used:
    @echo off
    sc \\Servername stop MSSQL$UDDI
    robocopy /s C:\Inetpub\uddi C:\Test_backup_Uddi
    sc \\Servername start MSSQL$UDDI

    Can you please let me know if am doing or using any syntax or command wrong
    here in the script. I created this as a batch file and did schedule it for
    run .

    Thanks

    Masti
     
    Masti, May 18, 2009
    #7
  8. When you write a batch file then it is a little optimistic to run it under
    the Task Scheduler without first testing it extensively in a Command Prompt.
    Perhaps you'll get some error message saying that the service cannot be
    stopped for one reason or the other. At the very least you should include
    some logging code in your batch file, e.g. like so:
    @echo off
    echo %date% %time% %UserName% >> c:\test.txt
    sc \\Servername stop MSSQL$UDDI 1>>c:\test.txt 2>>&1
    robocopy /s C:\Inetpub\uddi C:\Test_backup_Uddi
    sc \\Servername start MSSQL$UDDI 1>>c:\test.txt 2>>&1

    A frequently overlooked cause of failure for scheduled batch files is that
    the account used by the Task Scheduler has insufficient access rights to the
    resource it is trying to access.
     
    Pegasus [MVP], May 18, 2009
    #8
  9. Masti

    Masti Guest

    Hi,

    I did run the script it works fine copying data but actually i believe its
    not able to stop the service and copy all the data reason is Under UDDI
    whatever data is under Data folder is not being copied over.

    I see these messages in the log.

    Thu 05/21/2009 13:43:20.14 praveen-adm
    [SC] OpenSCManager FAILED 1722:

    The RPC server is unavailable.

    [SC] StartService FAILED 1056:

    An instance of the service is already running.

    does it make any sense to you .. can you please help me.
     
    Masti, May 21, 2009
    #9
  10. Masti

    Masti Guest

    I get this eror message now ,

    SERVICE_NAME: MSSQL$UDDI
    TYPE : 10 WIN32_OWN_PROCESS
    STATE : 3 STOP_PENDING
    (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)
    WIN32_EXIT_CODE : 0 (0x0)
    SERVICE_EXIT_CODE : 0 (0x0)
    CHECKPOINT : 0x1
    WAIT_HINT : 0xea60

    SERVICE_NAME: MSSQL$UDDI
    TYPE : 10 WIN32_OWN_PROCESS
    STATE : 2 START_PENDING
    (NOT_STOPPABLE, NOT_PAUSABLE,
    IGNORES_SHUTDOWN))
    WIN32_EXIT_CODE : 0 (0x0)
    SERVICE_EXIT_CODE : 0 (0x0)
    CHECKPOINT : 0x0
    WAIT_HINT : 0x7d0
    PID : 2588
    FLAGS :

    Script is @echo off
    echo %date% %time% %UserName% >> c:\test.txt
    sc \\ussf-papp-win01 stop MSSQL$UDDI 1>>c:\test.txt 2>>&1
    robocopy /s C:\Inetpub\uddi C:\Test_backup_Uddi
    sc \\ussf-papp-win01 start MSSQL$UDDI 1>>c:\test.txt 2>>&1

    Please help

     
    Masti, May 21, 2009
    #10
  11. Sorry, I have never succeeded in stopping a service that the commands "net
    stop" or "sc stop" failed to stop.


     
    Pegasus [MVP], May 21, 2009
    #11
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.