backup and restore گرفتن پشتیبان از دیتابیس و بازگردانی آن

[mousa1992]

connectionString :

            Connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector  y|\QuranDB.mdf;Integrated Security=True;User Instance=True");

CreateBackup:

        public void CreateBackUp(string Path)

        {

            string Command = @"backup database [" + Application.StartupPath + @"\QuranDB.mdf] to disk='" + Path + "'";



            CMD = new SqlCommand(Command, DAl.Connection);

            DAl.Connect();

            CMD.ExecuteNonQuery();

            DAl.DisConnect();

        }

Restore .bak File :

        public void RestoreBackUp(string Path)

        {

            SqlConnection.ClearAllPools();

            DAl.Connect();

            string FirstCommand = @"USE master;ALTER DATABASE ["+Application.StartupPath+"\\QuranDB.mdf] SET OFFLINE WITH ROLLBACK IMMEDIATE";

            CMD = new SqlCommand(FirstCommand, DAl.Connection);

            CMD.ExecuteNonQuery();

            string Command = @"restore database ["+Application.StartupPath+@"\QuranDB.mdf] from disk='" + Path + "'";

            CMD = new SqlCommand(Command, DAl.Connection);

            CMD.ExecuteNonQuery();

            DAl.DisConnect();

        }

حالشو ببر