UPS shutdown scripts for SAP / MS SQL Server on Windows 2003
in [SAP]
|
Prev: ups shutdowns scripts for sap / oracle on win 2003
Next: UPS shutdown scripts for SAP / MS SQL Server on Windows 2003 - solution
From: riggor9999 on 10 Jan 2010 11:50 Hello - I posted this a few months ago - but I have since changed from Oralce to MS-SQL Server 2005. I still have the same problem .... We normally run Unix / Oracle, but I now have a sandbox running two SAP instances (Sol Man 7.0 and CRM 7.0 IDES) on Windows 2003 / MS SQl Server 2005. I am trying write windows scripts to stop SAP and stop MS SQL Server instances when the UPS senses a power failure / low battery. This was very easy with Unix as "stopsap" will stop SAP and the database. While in windows "stopsap" only stops SAP, not MS SQL Server. Years ago - on Win2K / 4.6C ... I could issue a "sapdba -shutdown" command and that worked just fine, but I am now having trouble with brtools and brspace at the command line. When I issue a "brspace -f dbshut -mode normal -confirm force" ... I still get the brtools menu to confirm / interact. I need this to be automated without human interaction. Does anyone have any experience with this? I have googled and searched but have not found a simple / elegant way. The other factor is that I have two SAP instances and two MS SQL Server instances - which I need to be able to run once script, as Administrator to to stop both SAP and MS SQL Server instances. Bottom line is - I need a Windows 2003 cmd script to run an automated SAP and MS SQL shutdown for two instances as Administrator when the OS / UPS senses a power loss / low battery condition. Thanks in advance. |