[62307] in SAPr3-news
UPS shutdown scripts for SAP / MS SQL Server on Windows 2003
daemon@ATHENA.MIT.EDU (riggor9999)
Sun Jan 10 11:58:15 2010
To: sapr3-news@mit.edu
Date: Sun, 10 Jan 2010 11:50:44 -0500
From: "riggor9999" <riggor9999@nospam_yahoo.com>
Message-ID: <hid0h9$uqm$1@news.eternal-september.org>
Reply-To: "riggor9999" <riggor9999@nospam_yahoo.com>
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.
