从VB.NET 2005中Windows应用程序中的客户端计算机进行数据库备份 [英] Database Backup from Client Machine in Windows Application in VB.NET 2005

问题描述

我有一个用VB.NET 2005开发的Windows应用程序，正在将数据库用作Sql Server2000.

在我的应用程序中，我有一个数据库备份"选项，具有以下代码，

I have a Windows Application developed in VB.NET 2005, I am using Database as Sql Server 2000.

In my application, i have a Database Backup option has the Following Code,

                Dim conn As New ServerConnection(server, uid, pwd)
                Dim oSQLServer As New Server(conn) ''--create the SMO server object using connection
                SaveFileDialog1.FileName = db + ".bak"
                SaveFileDialog1.ShowDialog()
                Dim s As String
                s = SaveFileDialog1.FileName
                Dim bkDevItem As New BackupDeviceItem(s, DeviceType.File) '' -- create SMO.Backupdevice object
                oBackup = New Backup()
                With oBackup '' Set the backup object property
                    .Action = BackupActionType.Database
                    .Database = db
                    .Devices.Add(bkDevItem)
                    .Initialize = True
                    .Checksum = True
                    .ContinueAfterError = True
                    .Incremental = False
                    .LogTruncation = BackupTruncateLogType.Truncate
                    .SqlBackup(oSQLServer) '' backup SQL database
                End With</pre>

It''s working Fine, but when i am running from client machine the it shows the error Message ''Backup Failed for the Server XXXXXXX''

I was changed the Connection string needed server.

Any Suggestion would be Helpful.

Thanks

推荐答案

我是客户端计算机上的用户没有创建备份文件的权限吗?

My be the user on client machine does not have permissions to create backup file?

也许是您的问题与bkDevItem一起使用，这是客户端计算机的本地路径.
备份sql数据库时，设备路径应该是服务器计算机上的路径.
出于测试目的，将s = SaveFileDialog1.Filename更改为s ="c:\ someofolderYouCreatedAtServer \ yourbackupfile.bak"

Maybe your problem is with bkDevItem which is a local path of the client machine.
When you backup a sql database, the device path should be one from the server machine.
For test purposes, change s = SaveFileDialog1.Filename to s = "c:\someofolderYouCreatedAtServer\yourbackupfile.bak"

这篇关于从VB.NET 2005中Windows应用程序中的客户端计算机进行数据库备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！