Stop windows service copy data and then start service

Stop windows service copy data and then start service

Post by TWFzdG » Wed, 13 May 2009 06:52:01


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.
 
 
 

Stop windows service copy data and then start service

Post by Pegasus [M » Wed, 13 May 2009 07:58:41


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.

 
 
 

Stop windows service copy data and then start service

Post by TWFzdG » Wed, 13 May 2009 08:07:01

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
 
 
 

Stop windows service copy data and then start service

Post by Al Dunba » Wed, 13 May 2009 09:54:35


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

/Al
 
 
 

Stop windows service copy data and then start service

Post by TWFzdG » Sun, 17 May 2009 01:21:01

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
 
 
 

Stop windows service copy data and then start service

Post by Pegasus [M » Sun, 17 May 2009 01:31:09

Download the help file "script56.chm" from the Microsoft site, then check
what it says about the "run" method.
 
 
 

Stop windows service copy data and then start service

Post by TWFzdG » Wed, 20 May 2009 01:21:03

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
 
 
 

Stop windows service copy data and then start service

Post by Pegasus [M » Wed, 20 May 2009 03:51:15

hen 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.


"Masti" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...


 
 
 

Stop windows service copy data and then start service

Post by TWFzdG » Sat, 23 May 2009 05:53:08

i,

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.

"Pegasus [MVP]" wrote:

 
 
 

Stop windows service copy data and then start service

Post by TWFzdG » Sat, 23 May 2009 06:14:04

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" wrote:

 
 
 

Stop windows service copy data and then start service

Post by Pegasus [M » Sat, 23 May 2009 06:16:01

orry, I have never succeeded in stopping a service that the commands "net
stop" or "sc stop" failed to stop.


"Masti" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...