Restoring Discount ASP SQLServer Backup to Local SQLServer

Hi,
Has anyone been able to restore a Discount ASP.NET SQLServer 2000 Backup to their local SQLServer ? I'm referring to the backup you can create from the 'Tools' tab in their database area of the control panel.

Any assistance would be appreciated

 

Whats the problem you are having?

 

I'm just not exactly sure how to do this... I have a basic local installation but when you go into the restore option via Enterprise Manager I don't see where you can just select any file...such as the .bak file created with the discount ASP.NET backup tool.


If command line is the only way.... I can give that a try.


Thanks!

 

Got it.... just created a local DB first using the same exact name as hosted on discout ASP.Net .... then used TSQL in Query Analyzer to run the following command:


RESTORE DATABASE DB_315834_members
FROM DISK = 'C:\Backups\DB_315834_members_backup.bak'

 

I'm getting this error:

The backup set holds a backup of a database other than the existing 'Travel' database.

any suggestions?