Is there an option to show the percentage completed similar to WITH STATS. didn't see one in the help file so...
further to this I am looking for it in teh command line style (I know the GUI has one) as follows (xp)
master..sqlbackup N'-SQL "BACKUP DATABASE [dbname] TO DISK = ''X:\backupname.sqb'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', INIT, COMPRESSION = 2"'
The GUI uses the sqbstatus extended stored procedure to report the number of bytes processed. The sqlbackup extended stored procedure cannot report progress interactively.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software Beyond compression - SQL Backup goodies under the hood, updated for version 8
Comments
further to this I am looking for it in teh command line style (I know the GUI has one) as follows (xp)
master..sqlbackup N'-SQL "BACKUP DATABASE [dbname] TO DISK = ''X:\backupname.sqb'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', INIT, COMPRESSION = 2"'
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8