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)