VB.NET:
If rdoRestore.Checked = True Then
Try
Dim oSQLServer As SQLDMO._SQLServer = New SQLDMO.SQLServerClass
Dim oRestore As SQLDMO.Restore = New SQLDMO.RestoreClass
Dim aString As String
path = System.IO.Directory.GetCurrentDirectory
aString = (path & "\Allfiles\Database\SensorNET_Backup")
MsgBox(aString)
oRestore.Files = aString
oRestore.Database = "SensorNET"
oRestore.ReplaceDatabase = True
oSQLServer.Connect(cboServerName.Text, txtUserName.Text)
oRestore.SQLRestore(oSQLServer)
MsgBox("Database is Restored")
Catch err As Exception
MsgBox(err.Message())
End Try
End If
i will display the error:-
BackupDiskFileenMedia: Backup device 'C:\AppTest_working_folder\SensorNET_FinalRelease_20080220\Source' failed to open. Operating system error = 2(The system cannot find the file specified.).
2008-02-24 22:36:12.22 spid51 BackupDiskFileenMedia: Backup device
because
my Application is exist in source Code folder.This folder contain the space.for example "Source Code"
can u help me?
Last edited by a moderator: