I have a sql2k database (incidentally merge replicated to remote location).
I backed up a database then deleted some records. I now need to restore the backup to a new database on the same machine (to get at some of the records I deleted). As I understand it it will use the same filename for the restored database - meaning it cant be done on the same machine.
How can I restore it as a new database?