Backup job percent completed

Hi,
My backup job is still running, I see the job showing executing, but how do I check in QA how many percent of the backup has completed?
motioneyeAsked:
Who is Participating?
 
Eugene ZCommented:
check from EM (sql server->
management->Current activity ->
Process Info-> ProcessID
for your Backup job (e.g 61)

then in QA
run
DBCC OUTPUTBUFFER(61)
in result (right part ) you will see   percent completed....

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_4rea.asp
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Run sp_who2 and check how many processes are running on this database, may be some index defrag / dbcc checkdb  commands are running , also check for the free space in the backup device
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
This has to be the command to get the stats

BACKUP DATABASE urDb
TO  DISK = 'C:\urDB.Bak'
WITH
Stats = 10
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
motioneyeAuthor Commented:
ok from the result below, which one that point to percent complete?

Output Buffer                                                            
------------------------------------------------------------------------
01fb8028:  04 00 01 5f 00 00 00 00 e3 1b 00 01 06 6d 00 61  ..._.........m.a
01fb8038:  00 73 00 74 00 65 00 72 00 06 6d 00 61 00 73 00  .s.t.e.r..m.a.s.
'...'
01fb8218:  04 17 00 00 00 00 00 d1 04 18 00 00 00 00 00 d1  ................
01fb8228:   .

(33 row(s) affected)
0
 
Eugene ZCommented:
there is not - do you see  there 'percent '?
are you sure it is right spid#?

try

DBCC INPUTBUFFER(61) --> it will show you t-sql  like "BAckup ...."

DBCC OUTPUTBUFFER(61)
0
 
Eugene ZCommented:
motioneye :


did DBCC OUTPUTBUFFER help you?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.