What are the challenges you face when working across database platforms? Take the survey
Options

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...

Comments

  • Options
    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"'
  • Options
    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
Sign In or Register to comment.