建站
咨詢
售后
建站咨詢
新聞中心
此文章主要向大家講述的是在那種情況下會出現(xiàn)SQL Server數(shù)據(jù)庫中SMO備份數(shù)據(jù)庫進(jìn)度條不顯示，同時存在一個十分奇怪的問題，用SMO備份SQL Server數(shù)據(jù)庫時不顯示進(jìn)度條，也就是進(jìn)度條事件PercentComplete不觸發(fā)。
網(wǎng)站設(shè)計制作過程拒絕使用模板建站；使用PHP+MYSQL原生開發(fā)可交付網(wǎng)站源代碼;符合網(wǎng)站優(yōu)化排名的后臺管理系統(tǒng)；成都做網(wǎng)站、網(wǎng)站建設(shè)收費合理；免費進(jìn)行網(wǎng)站備案等企業(yè)網(wǎng)站建設(shè)一條龍服務(wù).我們是一家持續(xù)穩(wěn)定運營了十余年的成都創(chuàng)新互聯(lián)公司網(wǎng)站建設(shè)公司。
今天試了一下，果然有點奇怪。
一個奇怪的問題，用SMO備份SQL Server數(shù)據(jù)庫時不顯示進(jìn)度條，也就是進(jìn)度條事件PercentComplete不觸發(fā)。
今天試了一下，果然有點奇怪。
代碼如下：
- using Microsoft.SqlServer.Management.Smo;
- using Microsoft.SqlServer.Management.Common;
- private void btnBackup_Click(object sender, EventArgs e)
- {
- btnBackup.Enabled = false;
- Thread tr = new Thread(new ThreadStart(doBackup));
- tr.Priority = ThreadPriority.AboveNormal;
- tr.Start();
- //Thread.Sleep(3000);
- }
- ///
- /// 備份數(shù)據(jù)庫
- ///
- public void doBackup()
- {
- pbDemo.Value = 0;
- pbDemo.Maximum = 100;
- pbDemo.Style = ProgressBarStyle.Blocks;
- //pbDemo.Step = 10;
- Server srv = new Server(@"(local)");
- Backup backup = new Backup();
- backup.Action = BackupActionType.Database;
- backup.Database = "btnet";
- backup.Incremental = false;
- backup.Devices.Add(new BackupDeviceItem(@"C:\agronet09.bak", DeviceType.File));
- backup.Initialize = true;
- backup.PercentCompleteNotification = 10;
- backup.PercentComplete += new PercentCompleteEventHandler(backup_PercentComplete);
- //backup.Checksum = true;
- backup.SqlBackup(srv);
- }
- public void backup_PercentComplete(object sender, Microsoft.SqlServer.Management.Smo.PercentCompleteEventArgs e)
- {
- this.Invoke(new displayProgress_delegate(displayProgress), e.Percent);
- //Application.DoEvents();
- }
- public delegate void displayProgress_delegate(int progress);
- public void displayProgress(int progress)
- {
- this.lbProgress.Text = "已完成[" + progress.ToString() + " %]";
- pbDemo.Value = progress;
- btnBackup.Enabled = (progress == 100);
- }
癥狀如下：結(jié)果正確執(zhí)行，但進(jìn)度條不顯示。
剛開始以為是線程問題，后來發(fā)現(xiàn)不是這個原因。
又試了另外一段代碼
- using Microsoft.SqlServer.Management.Smo;
- using Microsoft.SqlServer.Management.Common;
- using System.Diagnostics;
- static void Main(string[] args)
- {
- BackupDatabase("ap4\\agronet09", "agronet2008", "c:\\Northind_3.bak");
- Console.WriteLine(Environment.NewLine + "Press any key to continue.");
- Console.ReadKey();
- }
- public static void BackupDatabase(string serverName, string databaseName, string fileName)
- {
- Console.WriteLine("*** Backing up ***");
- Server server = new Server(serverName);
- Backup backup = new Backup();
- backup.Action = BackupActionType.Database;
- backup.Database = databaseName;
- backup.Incremental = false;
- backup.Initialize = true;
- backup.LogTruncation = BackupTruncateLogType.Truncate;
- BackupDeviceItem backupItemDevice = new BackupDeviceItem(fileName, DeviceType.File);
- backup.Devices.Add(backupItemDevice);
- backup.PercentCompleteNotification = 10;
- backup.PercentComplete += backup_PercentComplete;
- backup.Complete +=backup_Complete;
- backup.SqlBackup(server);
- }
- protected static void backup_PercentComplete(object sender, PercentCompleteEventArgs e)
- {
- Console.WriteLine(e.Percent + "% processed.");
- //Application.();
- System.Threading.Thread.Sleep(1000);
- }
- protected static void backup_Complete(object sender, ServerMessageEventArgs e)
- {
- Console.WriteLine(Environment.NewLine + e.ToString());
- }
結(jié)果還是不顯示。
后來突然想到會不會是文件太小，試了一個200M的數(shù)據(jù)文件，果然成功顯示：
后來經(jīng)反復(fù)實驗，發(fā)現(xiàn)SQL server 2000約在數(shù)據(jù)文件加日志文件大于6M左右時顯示進(jìn)度條。
而Sql server 2008 r2大約在3M時顯示進(jìn)度條?？赡芨鷻C(jī)器也有關(guān)系。
以上的相關(guān)內(nèi)容就是對SQL Server數(shù)據(jù)庫中SMO備份數(shù)據(jù)庫進(jìn)度條的介紹，望你能有所收獲。
分享題目：在那種情況下SQLServer數(shù)據(jù)庫中SMO進(jìn)度條不顯示？
當(dāng)前鏈接：http://www.5511xx.com/article/coeoess.html
