>I posted this question in the .NET section of UT, but since I have received no replies yet I thought I would post it here too.
>
>I have created a small little backup/restore application for backingup/restoring a MSSQL database. Everything is working just fine but I would like to give the user a little more feedback regarding how much is left of the backup/restore process. I know about the STATS [ = percentage] but I am unsure how I can get that information back to my app.
>Here is how I execute the backup/restore script in my app:
>
>

>SqlConnection sqlCon = new SqlConnection(this.ConnectionString);
>SqlCommand sqlCmd = new SqlCommand();
>sqlCmd.Connection = sqlCon;
>sqlCmd.CommandText = this.SqlScript;
>sqlCon.Open();
>sqlCmd.ExecuteNonQuery();
>sqlCon.Close();
>

>
>Any info on the topic would be appreciated.
>
>Thanks,
>Einar

Einar,

I don't think that ADO.NET is going to give you what you want. However, SQL-DMO (2000) or SQL-SMO (2005) Backup class includes a PercentCompleteEventHandler delegate.