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:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:39 AM To: [EMAIL PROTECTED] 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
