Backup and Restore SQL database with vb.net

[ninel]

I have the following code:

Dim oSQLServer As New SQLDMO.SQLServer
Dim oBackup As New SQLDMO.Backup
Dim oRestore As New SQLDMO.Restore
Dim BACKUPFILE As String
Dim DATABASE As String

BACKUPFILE = "C:\VoicenetSQL\project\tampa\Politic\" & ProjectFolder & "\VoiceNet_TemplateBackup.bkp"
       
DATABASE = "VoiceNet_at0000"

With oBackup
            .Files = BACKUPFILE
            .Database = DATABASE
            .BackupSetName = "VoiceNet"
            .BackupSetDescription = "Backup from VB.NET application"
            .oSQLServer.Connect("NINEL-D246655F1", "timecontroluser", "timecontroluser")
            .SQLBackup(oSQLServer)
        End With
        
        oSQLServer.DisConnect()

This is not working. I am getting the following error:
"Public member 'oSQLServer' on type 'BackupClass' not found."

Does anyone know how to accomplish this?

Thanks,
Ninel

[Phil Weber]

Let IntelliSense help you: Inside your "With oBackup" block, press the period (.) key, and look at the dropdown list of properties and methods. You'll find that there is not one called "oSQLServer," which is why you're getting the error. I suspect that you intend to call oSQLServer.Connect directly, without the preceding period.

[ninel]

I got that working. I needed to move the oSQLServer.Connect("NINEL-D246655F1", "timecontroluser", "timecontroluser") out of the with statement.

I am now having an issue with the restore.

I have a db called Voicenet_Template (this is the db I backed up).
Now I'd like to restore the backup, but with a different database name and therefore different log and mdf files.

The backup file is for db Voicenet_Template which has log(Voicenet_Template_log.ldf) and data files (Voicenet_Template.mdf).

The new db should be Voicenet_ABC and log and mdf files Voicenet_ABC_log.ldf and Voicenet_ABC.mdf

Do you know how I can do this?

Thanks,
Ninel