Try putting a pause statement at the end of your batch file and run it manually.
this will allow you to view any errors.
If it runs OK running manually,  then your tsm scheduler service is probably
running under an account that doesn't have rights to stop the database.
Make sure that you are stopping the SQL Services in the proper order.
If when running manually, you get a message that says one service is dependent
on another then you will need to stop the dependant service first.



-----Original Message-----
From:   Coats, Jack [SMTP:Jack.Coats AT BANKSTERLING DOT COM]
Sent:   Thursday, January 09, 2003 10:39 AM
To:     ADSM-L AT VM.MARIST DOT EDU
Subject:        DOS Return-Code Primmer for PRECOMMAND and POST processing

Does anyone have a URL or reference for me?  I need to use DOS batch files
to bring down and up an SQL database.
I have the batch file, but it is returning a 1 as a return code and that is
keeping the backups from occurring.
... TIA ... Jack