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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)