Restoration status

Question

Restoration status

preeth.cs

Valued Member

Points: 58
More actions
November 25, 2009 at 8:48 am

#74199

While restoration, how can identify the status of restoration, that is how many bytes completed, how many bytes yet to complte so on

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Check the percent_complete column in sys.dm_exec_requests. I think that restore is one of the operations that populates it.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 737004 More actions · Answer 2

http://msdn.microsoft.com/en-us/library/ms177648%28SQL.90%29.aspx

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 3

Forgive my ignorance, but aren't those both suggestions to DMVs? That should not be available in SQL 2000, right? Is there an equivalent or similar solution for SQL 2000?

Joie Andrew
"Since 1982"

Steve Jones - SSC Editor SSC Guru Points: 737004 More actions · Answer 4

Doh! You are correct. Didn't check the forum. Those are 2005 and later solutions.

In 2000, if you didn't start the restore with the STATS parameter, you won't get this

http://msdn.microsoft.com/en-us/library/aa238405%28SQL.80%29.aspx

george sibbald SSC Guru Points: 104210 More actions · Answer 5

If I remember correctly if you run dbcc outputbuffer on the spid running the restore it tells you how far it has got.

dbcc outputbuffer(spid)

---------------------------------------------------------------------