backup percent complete

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

backup percent complete

Postby lholloway@scrippsnetworks » Mon Jul 22, 2013 8:04 pm

Does the backup function have the ability to indicate percent completion for long running backups?
lholloway@scrippsnetworks
 
Posts: 1
Joined: Mon Jul 22, 2013 8:01 pm

Postby petey » Tue Jul 23, 2013 1:22 am

No it does not. You can run the sqbstatus extended stored procedure to find out how much data has been backed up e.g.

Code: Select all
EXEC master..sqbstatus 1
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests