-o database server option

All operating systems.

Print all database server messages, including informational messages, errors, warnings, and MESSAGE statement output, to the specified file, and to the database server messages window. If you specify the -qi option with -o, all messages appear only in the database server message log file.

Do not end the file name with .log because this can create problems for utilities that perform operations using the transaction log.

To find the name of the database server message log file, execute the following statement:

SELECT PROPERTY ( 'ConsoleLogFile' );