get restore progress using T-SQL

Question

get restore progress using T-SQL

Jules Bonnot

SSCertifiable

Points: 5488
More actions
June 18, 2007 at 3:54 am

#117510

When a restore is done using the interface it displays a progress percentage in 2005 or blue blobs in 2000.

I have restarted managment studio and now cant see the progress. This is an enormous DB and i need to see how the restore is progressing is there a way i can retrieve this information using T-SQL.

Thanks for any help.
Jules
www.sql-library.com[/url]

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

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

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

Do you mean that you have closed the window that was restoring the database if so your restore would have got failed and the database will be seen in the server in loading state. Check if thats the case for you.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Jules Bonnot SSCertifiable Points: 5488 More actions · Answer 2

nope just logged of the client terminal. Restore is in progress.

www.sql-library.com[/url]

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

Logging off will close all active windows. I am not sure what you are trying to say. Logged off from terminal or disconnected. of disconnected then you process will go else if logged off it would have got terminated.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Jules Bonnot SSCertifiable Points: 5488 More actions · Answer 4

logged out of windows the restore takes place on the server.

www.sql-library.com[/url]

noeld SSC Guru Points: 96590 More actions · Answer 5

to see the progress in T-SQL you add STATUS=10 for example and your client will recieve a message every 10% completion. If what you want to know is how far is the restore done from a client that did not start it; you can check the "percent_complete" column of "sys.dm_exec_requests"

* Noel