Hi All,

I backed up a copy of a production MS-SQL database to use for a test system in which I had to add new tables fields etc . I now need to restore this back to the original production server under a different database name without overriding the original .

I didn't realise that this would be so difficult, can anyone shed some light on the best approach to take..

I have tried specifying an alternate SQLData folder , and also an alternate .mdf filename , but it keeps telling me that the database is in use.