I have two scripts to run SQL Server backups. The full now executes great thanks to the people on this board. The incr executes in the same manner but does not back up any data.
Here is the backup line in the script:
The script executes, but I get this in the log. notice that it states backups attempted=0:
Can I not use the "*" in a logback up?
Here is the backup line in the script:
Code:
tdpsqlc backup * log /tsmnode=WMSTUTENG1_S /tsmp=xxxxx /tsmoptfile=dsm.opt /logfile=sqlinc.log
The script executes, but I get this in the log. notice that it states backups attempted=0:
Code:
04/17/2009 08:48:22 Request : LOG BACKUP
04/17/2009 08:48:22 Database Input List : *
04/17/2009 08:48:22 Group Input List : -
04/17/2009 08:48:22 File Input List : -
04/17/2009 08:48:22 Number of Buffers : 3
04/17/2009 08:48:22 Buffer Size : 1024
04/17/2009 08:48:22 Number of SQL Buffers : 0
04/17/2009 08:48:22 SQL Buffer Size : 1024
04/17/2009 08:48:22 Number of Stripes specified : 1
04/17/2009 08:48:22 Estimate : 0
04/17/2009 08:48:22 Truncate Log? : Yes
04/17/2009 08:48:22 Wait for Tape Mounts? : Yes
04/17/2009 08:48:22 TSM Options File : C:\Progra~1\Tivoli\TSM\TDPSql\dsm.opt
04/17/2009 08:48:22 TSM Nodename Override : WMSTUTENG1_S
04/17/2009 08:48:22 Sqlserver : WMSTUTENG1\OASYSHDB
04/17/2009 08:48:22
04/17/2009 08:48:23 Total SQL backups selected: 13
04/17/2009 08:48:23 Total SQL backups attempted: 0
04/17/2009 08:48:23 Total SQL backups completed: 0
04/17/2009 08:48:23 Total SQL backups excluded: 13
04/17/2009 08:48:23 Throughput rate: 0.00 Kb/Sec
04/17/2009 08:48:23 Total bytes transferred: 0
04/17/2009 08:48:23 Elapsed processing time: 0.00 Secs
Can I not use the "*" in a logback up?