We help IT Professionals succeed at work.

Backup job percent completed

motioneye
motioneye asked
on
Medium Priority
497 Views
Last Modified: 2008-02-01
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?
Comment
Watch Question

AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
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
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
This has to be the command to get the stats

BACKUP DATABASE urDb
TO  DISK = 'C:\urDB.Bak'
WITH
Stats = 10
SQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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)
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT

Commented:
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)
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT

Commented:
motioneye :


did DBCC OUTPUTBUFFER help you?
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.