hi
i want to back up my data and save it to my hard disk and restore it again by C#
please help me

best regards
kiani mehdi

Hi,

You can create a command and execute the "BACKUP DATABASE". Take a look at the following sample:

            System.Data.SqlClient.SqlConnection connection = null;

            try
            {
                connection = new System.Data.SqlClient.SqlConnection();
                connection.ConnectionString = "Server=<server>;Initial Catalog=<db>;Integrated Security=SSPI; User Id=<user>;Password=<password>";

                System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand();
                command.CommandText = @"BACKUP DATABASE <db> TO DISK='C:\filename.bak'";
                command.Connection = connection;
                connection.Open();
                command.ExecuteNonQuery();
            }
            catch (System.Exception ex)
            {
                System.Console.WriteLine(ex.Message);
            }
            finally
            {
                if ((connection != null) && (connection.State != System.Data.ConnectionState.Closed))
                {
                    connection.Close();
                    connection.Dispose();
                }
            }

Regards.

hi,
thank's so much for your usefull help

can you tell me how i can restore it from c#.net ?

bet regards
kiani

hi,
thank you
and about restoring database i can restor database in fllowing steps
1)i set the data base to single_user then
2)i restor database with restore database SP
3)and finally i set database to multiple user

but in this way i have to write Application.Exitthread() at the end of step 3 becaus my app began hang up

what is the problem?
is there a better way for restoring database?