none
Scripting issue, nothing happens when script is running

    Question

  • I have an issue trying to stop SQLEXPRESS service on a specific client prior to the DPM backup. 
    Yes it's snapshot but I still want to do it. 

    This is my ScriptingConfig.xml on SRV0023: 

    <?xml version="1.0" encoding="utf-8"?>
    <ScriptConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
     xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
     xmlns="http://schemas.microsoft.com/2003/dls/ScriptingConfig.xsd">
    <DatasourceScriptConfig DataSourceName="Backup Using Child Partition Snapshot\SRV0023">
    <PreBackupScript>C:\Repository\Script\stopsqlps.cmd</PreBackupScript>
    <PostBackupScript>C:\Repository\Script\startsqlps.cmd</PostBackupScript>
    <TimeOut>30</TimeOut>
    </DatasourceScriptConfig>
    </ScriptConfiguration>

    stopsqlps.cmd :
    "C:\Windows\system32\WindowsPowershell\v1.0\powershell.exe" -File c:\scripts\stopscript.ps1 -d stop-service -displayname "SQL Server (SQLEXPRESS)" -Force

    startsqlps.cmd :
    "C:\Windows\system32\WindowsPowershell\v1.0\powershell.exe" -File c:\scripts\startscript.ps1 -d start-service -displayname "SQL Server (SQLEXPRESS)"

    stopscript.ps1: 
    net stop "SQL SERVER (SQLEXPRESS)"

    startscript.ps1: 
    net start "SQL SERVER (SQLEXPRESS)"

    Scrips seems to run but the SQLEXPRESS service is not affected (stopped/started) when the backup is running. 
    Eventlog gives no clues. 

    The DataSourceName is identical with the name in the DPM Console GUI. 

    The cmd-files can successfully be processed from command line and then the service is stopped and started. 

    What have I missed here? 

     
    Thursday, April 03, 2014 1:31 PM

All replies

  • Not a single reply? 

    I've been trying to enable verbose logging to find out what's causing my problem by using these links: 

    http://technet.microsoft.com/en-us/library/hh872928.aspx

    http://blogs.msdn.com/b/george_bethanis/archive/2013/11/04/how-to-collect-dpm-verbose-logs.aspx

    http://social.technet.microsoft.com/Forums/en-US/f6dd71fe-ea8d-498b-85db-3f86a5734bd3/dpm-2012-sp1-error-pre-postbackupscript?forum=dataprotectionmanager

    but I can't find the string 
    CCreateSnapshotSubTask::ExecutePreScript
    as found int the last link. 

    All help is appreciated. 

    Monday, April 07, 2014 1:39 PM