Percentage complete

neilmcseneilmcse Posts: 8
edited August 19, 2006 3:29AM in SQL Backup Previous Versions
Is there an option to show the percentage completed similar to WITH STATS. didn't see one in the help file so...
· Share on Twitter

Comments

  • neilmcseneilmcse Posts: 8
    neilmcse wrote:
    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"'
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    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
    · Share on Twitter
Sign In or Register to comment.