Finding SQL Server recovery execution from inside C #

Question

I know that this is most likely a simple question, but when you restore the database from inside the SQL management studio, you can set the update interval with statistics

RESTORE DATABASE [test] FROM  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\test.bak' WITH  FILE = 1,  NOUNLOAD,  STATS = 10

If I wanted to execute this line of code from within C #, how would I be able to make progress? Currently, I just use System.Data.SqlClient.SqlCommand.ExecuteNonQuery(), but I can’t figure out how to make progress.

Also, if it is faster, using the Microsoft.SQLServer namespace is acceptable.

Answer 1

ExecuteNonQuery . , , SMO, , . http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.restore.aspx http://msdn.microsoft.com/en-us/library/ms162133.aspx PercentComplete

Answer 2

:

SELECT @@SPID;

. sys.dm_exec_requests percent_complete , restore:

:

• ALTER INDEX REORGANIZE
• AUTO_SHRINK ALTER DATABASE
• CREATE INDEX
• DBCC CHECKDB
• DBCC CHECKFILEGROUP
• DBCC
• DBCC INDEXDEFRAG
• DBCC SHRINKDATABASE
• DBCC SHRINKFILE
• KILL (Transact-SQL)
• .