建站
咨詢(xún)
售后
建站咨詢(xún)
新聞中心
我們今天主要向大家描述的是SQL Server SMO備份數(shù)據(jù)庫(kù)進(jìn)度條不顯示這一問(wèn)題，假如你在實(shí)際操作中遇到相似的情況，但是你卻不知道對(duì)其如何正確的解決，那么以下的文章對(duì)你而言一定是良師益友。
創(chuàng)新互聯(lián)公司是專(zhuān)業(yè)的海安網(wǎng)站建設(shè)公司，海安接單;提供成都網(wǎng)站建設(shè)、成都網(wǎng)站制作,網(wǎng)頁(yè)設(shè)計(jì),網(wǎng)站設(shè)計(jì),建網(wǎng)站,PHP網(wǎng)站建設(shè)等專(zhuān)業(yè)做網(wǎng)站服務(wù);采用PHP框架,可快速的進(jìn)行海安網(wǎng)站開(kāi)發(fā)網(wǎng)頁(yè)制作和功能擴(kuò)展;專(zhuān)業(yè)做搜索引擎喜愛(ài)的網(wǎng)站,專(zhuān)業(yè)的做網(wǎng)站團(tuán)隊(duì),希望更多企業(yè)前來(lái)合作!
一個(gè)奇怪的問(wèn)題，用SQL Server SMO備份數(shù)據(jù)庫(kù)時(shí)不顯示進(jìn)度條，也就是進(jìn)度條事件PercentComplete不觸發(fā)。 今天試了一下，果然有點(diǎn)奇怪。
代碼如下：
- 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ù)庫(kù)
- ///
- 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)度條不顯示。
剛開(kāi)始以為是線程問(wèn)題，后來(lái)發(fā)現(xiàn)不是這個(gè)原因。
又試了另外一段代碼
- 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é)果還是不顯示。
后來(lái)突然想到會(huì)不會(huì)是文件太小，試了一個(gè)200M的數(shù)據(jù)文件，果然成功顯示：
后來(lái)經(jīng)反復(fù)實(shí)驗(yàn)，發(fā)現(xiàn)SQL server 2000約在數(shù)據(jù)文件加日志文件大于6M左右時(shí)顯示進(jìn)度條。
而Sql server 2008 r2大約在3M時(shí)顯示進(jìn)度條?？赡芨鷻C(jī)器也有關(guān)系。
以上的相關(guān)內(nèi)容就是對(duì)SQL Server SMO備份數(shù)據(jù)庫(kù)進(jìn)度條不顯示的介紹，望你能有所收獲。
【編輯推薦】
- SQL Server數(shù)據(jù)庫(kù)中可用格式字符串干什么？
- SQL Server 連接字符串的實(shí)現(xiàn)步驟
- SQL Server 連接字符串的一些聲明
- SQL Server 字符串在實(shí)際操作中的注意事項(xiàng)
- MS SQL Server 連接字符串的實(shí)際操作簡(jiǎn)介
網(wǎng)站標(biāo)題：SQLServerSMO備份數(shù)據(jù)庫(kù)進(jìn)度條不顯示的原因
文章源于：http://www.5511xx.com/article/cdegopp.html
