hi all

i want to restore the database and i found using smo is quite effective, however i got difficulity how to use it ?

Code:
        Dim datapathname As String
        Dim datalogname As String
        Dim destdbname as string
        Dim backupfilepath as string

      'datapath name and data logname is the pathfile of new data that will be overwriten by backupdata 

        datapathname = "F:\MSSQL\90\Data\DEV_ARIF.mdf"
        datalogname = "F:\MSSQL\90\Logs\DEV_ARIF_log.ldf"
        destdbname = "DEV_ARIF"
        backupfilepath = "F:\ARIF\Backup\Database\90\A\A_backup_200801292332.bak"        


        myrestore = New Restore()
        myrestore.Database = destdbname
        myrestore.Devices.AddDevice(backupfilepath, DeviceType.File)
        myrestore.NoRecovery = False
        myrestore.ReplaceDatabase = True

        ' Relocate the file
        myrestore.RelocateFiles.Add(New RelocateFile("DEV_ARIF", datapathname))
        myrestore.RelocateFiles.Add(New RelocateFile("DEV_ARIF_log", datalogname))


        myserver = New Server("arifliminto")

        myrestore.SqlRestore(myserver)
I always got error in " myrestore.sqlrestore(myserver)
it said i cannot restore failed for server arifliminto
but i think the name of the server is already right,

so anyone know where is the error