Restore status

Last Post 16 Jul 2010 12:06 PM by gunneyk. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sql-tips
New Member
New Member

--
15 Jul 2010 07:44 AM
I am restoring database using command and would like to know the status of the progress.

I used following

use master
go
restore database test
from disk = N' c:\test.bak'
with recovery;
russellb
New Member
New Member

--
15 Jul 2010 09:18 AM
use master
go

restore database test
from disk = N' c:\test.bak'
with stats, recovery;
sql-tips
New Member
New Member

--
15 Jul 2010 09:22 AM
thanks.
gunneyk
New Member
New Member

--
16 Jul 2010 12:06 PM
In addition to that you can always look at the Percent complete column of the sys.dm_exec_requests DMV for backups as well.


Acceptable Use Policy
---