Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

Recommended way to restore backup



  • Hi,
    What would be the recommended way to restore the ProGet database.

    All I could find was this article made for buildmaster: http://inedo.com/support/documentation/buildmaster/buildmaster-administration/backing-up

    Backup works fine with the command line:

    osql.exe -S .\PROGET -E -Q "BACKUP DATABASE [ProGet] TO DISK=N'c:\Backups\ProGet.bak' WITH FORMAT"

    I then did an attempt to restore the database on a ProGet of same version as when the backup was created.
    I stopped the ProGet service.
    And used the following command line:

    osql.exe -S .\PROGET -E -Q "RESTORE DATABASE [ProGet] FROM DISK = N'C:\Backups\ProGet.bak' WITH FILE = 1, NOUNLOAD, STATS = 10"

    This was not possible, the error message was:

    Msg 3154, Level 16, State 4, Server xxxx\PROGET, Line 1.
    The backup set holds a backup of a database other than the existing 'ProGet'database.
    Msg 3013, Level 16, State 1, Server WIN-OAE3LVGPN4P\PROGET, Line 1
    RESTORE DATABASE is terminating abnormally.
    

    Removing the ProGet database, makes the restore statement above complete successfully.

    Could you please outline a recommended way of doing a database restore?

    (ProGet Enterprise customer, Shure Scandinavia)

    Product: ProGet
    Version: 3.2.1



  • Deleting first is fine, you could also add a REPLACE to the restore's WITH clause, i.e.

    ... WITH FILE = 1, REPLACE, ...



  • Thank you, REPLACE works as intended.


Log in to reply
 

Inedo Website HomeSupport HomeCode of ConductForums GuideDocumentation