Backup SQL data only so that when alterations are made to database, data can still be imported.

public void BackupEntireSqlDatabaseToDisk(string fileName)
        {
            using (SqlConnection Conn = new SqlConnection(Connect.sConnStr))
            {
                Conn.Open();

                string database = Conn.Database.ToString();
                string sSql = string.Format("BACKUP DATABASE [" + database + "] TO DISK='{0}' WITH FORMAT", fileName);

                using (SqlCommand cmd = new SqlCommand(sSql, Conn))
                {
                    cmd.ExecuteNonQuery();
                }

                Conn.Close();
                Conn.Dispose();
            }
        }

        public void RestoreEntireSqlDatabaseToEzyGym(string fileName)
        {
            using (SqlConnection Conn = new SqlConnection(Connect.sConnStr))
            {
                Conn.Open();

                string database = Conn.Database.ToString();
                string UseMaster = "USE master";
                SqlCommand UseMasterCommand = new SqlCommand(UseMaster, Conn);
                UseMasterCommand.ExecuteNonQuery();

                string Alter1 = @"ALTER DATABASE [" + database + "] SET Single_User WITH Rollback Immediate";
                SqlCommand Alter1Cmd = new SqlCommand(Alter1, Conn);
                Alter1Cmd.ExecuteNonQuery();

                string Restore = string.Format("Restore database [" + database + "] from disk='{0}'", fileName);

                SqlCommand RestoreCmd = new SqlCommand(Restore, Conn);
                RestoreCmd.ExecuteNonQuery();

                string Alter2 = @"ALTER DATABASE [" + database + "] SET Multi_User";
                SqlCommand Alter2Cmd = new SqlCommand(Alter2, Conn);
                Alter2Cmd.ExecuteNonQuery();

                Conn.Close();
                Conn.Dispose();
            }
        }