Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restoration status Expand / Collapse
Author
Message
Posted Wednesday, November 25, 2009 8:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 4, 2014 12:59 PM
Points: 3, Visits: 212
While restoration, how can identify the status of restoration, that is how many bytes completed, how many bytes yet to complte so on
Post #824665
Posted Wednesday, November 25, 2009 12:13 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 42,765, Visits: 35,863
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 2008, MVP
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

Post #824844
Posted Wednesday, November 25, 2009 1:21 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:05 PM
Points: 33,165, Visits: 15,299
http://msdn.microsoft.com/en-us/library/ms177648%28SQL.90%29.aspx






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #824900
Posted Wednesday, November 25, 2009 3:03 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 7:28 AM
Points: 709, Visits: 1,417
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"
Post #824968
Posted Wednesday, November 25, 2009 3:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:05 PM
Points: 33,165, Visits: 15,299
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #824980
Posted Sunday, November 29, 2009 10:17 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 5,990, Visits: 12,923
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)


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

Post #825891
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse