PHISSUG

I am using iSQL from MS SQL Server 2000 tools to run a query thru command line. Have tried using the -o <outputfile> option but it only save the last command, it didnt append to a single log file. Is it possible to save activities thru a single logfile?

Hi mpMS,

instead of        -o outputfile.txt

use                  >> outputfile.txt       instead

~hope this will help

Thanks for this. Just noticed that the log doesnt contain date and time. Is it possible to include it on the log file?

please put

PRINT GetDate()   

in the script that you will going to run.

~hope this will help

Arthur Jr:

please put

PRINT GetDate()   

in the script that you will going to run.

~hope this will help

I am using this command:
isql -d myDB -U sa -P password -Q "BACKUP DATABASE myDB TO DISK='G:\Backup\myDB.BAK'" >> C:\myDB_log.log

It only have one SQL statement. How can I include the line that you gave on my script?

isql -d myDB -U sa -P password -Q "BACKUP DATABASE myDB TO DISK='G:\Backup\myDB.BAK' ; PRINT GetDate()" >> C:\myDB_log.log

 

~hth

or,

during my DOS days, I'd probably save the following in MYSCRIPTS.BAT

isql -d myDB -U sa -P password -Q "BACKUP DATABASE myDB TO DISK='G:\Backup\myDB.BAK' >> C:\myDB_log.log
date /t >> C:\myDB_log.log
time /t >> C:\myDB_log.log

or if you have multiple lengthy scripts, you can execute each query file (*.SQL) in batches. Check BOL for samples.

 

Have another question, what if I want to include the following on the log using the iSQL CLI:

sample logfile:

Backup Start Date: 09-15-2007 14:00
Database: myDB
Backup End Date: 09-15-2007 14:30
Database size: 100MB

Is this possible?

basically, you can have anything in the log. Anything that is displayed by iSQL can be captured. You can use PRINT inside the scripts to output anything to the log file.