08-24-2010 07:47 AM
Solved! Go to Solution.
09-07-2010 07:25 AM
08-24-2010 01:38 PM
If SQLINSTANCE $ALL is used, then it must appear in the first operation of
the batch file. Each operation in the batch file is performed for all SQL Server
instances on the client where the batch file is executed. Also, it is not necessary
to specify an SQLHOST or SQLINSTANCE on any subsequent operations.
08-24-2010 01:50 PM
08-24-2010 02:05 PM
The SQLINSTANCE $ALL will only work on a standalone machine with multiple SQL instances and is not designed to work on either a MSCS or Veritas cluster. The function makes a call to the physical "host" name and enumerates all SQL instances attached to that name - it does not enumerate SQL instances attached to a cluster group name."
08-24-2010 02:12 PM
08-24-2010 02:37 PM
08-25-2010 06:50 AM
08-25-2010 06:52 AM
08-25-2010 06:59 AM
08-25-2010 07:58 AM
08-25-2010 01:58 PM
08-26-2010 06:34 AM
SQLINSTANCE $ALL
OPERATION BACKUP
DATABASE $ALL
NBSERVER "BEARING"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
09-07-2010 07:25 AM
09-07-2010 12:23 PM