Solved

Backup job percent completed

Posted on 2006-10-29
6
387 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?
0
Comment
Question by:motioneye
  • 3
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17831786
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
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17831819
This has to be the command to get the stats

BACKUP DATABASE urDb
TO  DISK = 'C:\urDB.Bak'
WITH
Stats = 10
0
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 17833128
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:motioneye
ID: 17878089
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
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17878491
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
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17883454
motioneye :


did DBCC OUTPUTBUFFER help you?
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question