Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backup/restore progress
Message
 
À
06/03/2006 09:34:33
Keith Payne
Technical Marketing Solutions
Floride, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01101581
Message ID:
01101721
Vues:
11
Keith,
Information seems very promising. Thank you very much for the information.

Einar

>>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.
Semper ubi sub ubi.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform