C#

michaelgr1 wrote:

How can i do it?

using System.IO;

string FindFile(string initDirectory, string fileToFind)
{
  DirectoryInfo dir = new DirectoryInfo(initDirectory);
  foreach(FileInfo file in dir.GetFiles())
  {
    if(file.Name == fileToFind)
       return file.FullName;
  }
  foreach(DirectoryInfo subDir in dir.GetDirectories())
  {
    return FindFile(subDir.FullName, fileToFind);
  }
  return null;
}

public static void BackupDatabase(string DataBaseName , string Backupfile , string Description )
        {
            SqlCmd = new SqlCommand("BACKUP DATABASE @DataBaseName TO DISK = @Backupfilepath WITH INIT , DESCRIPTION = @Description", SqlCon);
            SqlCmd.Parameters.AddWithValue("@DataBaseName", DataBaseName);
            SqlCmd.Parameters.AddWithValue("@Backupfilepath", Backupfile);
            SqlCmd.Parameters.AddWithValue("@Description", Description);
            SqlCmd.ExecuteNonQuery();

        }