Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: sqldmo backup/restore problem

    thanks patrick, i've done that and heres my code:

    Dim oBackup As New SQLDMO.Backup

    Dim oSQLServer As New SQLServer

    oSQLServer.Connect "WENDY", "sa", ""

    oBackup.Action = SQLDMOBackup_Files

    oBackup.Database = "Jantzen"

    oBackup.DatabaseFiles = "Jantzen_Data"

    ' Example illustrates backup implemented...

  • RE: sqldmo backup/restore problem

    if you use the backup file generated by the application i've coded, yes it's corrupted.. but if i do it manually, and then restore again, theres no problem.

  • RE: sqldmo backup/restore problem

    i tried changing the restore code to include this:

    oRestore.DatabaseFiles = "Jantzen_Data"

    ------------------------------------------

    Dim oRestore As New SQLDMO.Restore

    Dim oSQLServer As New SQLServer

    oSQLServer.Connect "WENDY", "sa", ""

    oRestore.Action = SQLDMORestore_Files

    oRestore.Database = "Jantzen"

    oRestore.DatabaseFiles = "Jantzen_Data"

    oRestore.ReplaceDatabase = True

    oRestore.Files...

  • RE: sqldmo backup/restore problem

    btw, jantzenbackup.bak is a file i manually created using backup of sql server.

  • RE: sqldmo backup/restore problem

    yup! tried it.. same error..

    i changed

    oRestore.Files = Text1.Text

    to

    oRestore.Files = "d:\jantzenbackup.bak"

  • RE: sqldmo backup/restore problem

    text1.text contains the filename of the backup file to restore from.

    yep. this is to hide complexity from the user.

Viewing 6 posts - 1 through 6 (of 6 total)