Recommended way to restore backup

[Peter Eeg]

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

[Tod]

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

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

[Peter Eeg]

Thank you, REPLACE works as intended.