The same thing happens for the StarataframeSample database. But if I backup my own database, it restores fine onto Server2. Anybody throw any light on whats happening here ?
I can see Tools..Options in SSMS (2008) but cant see anything like Replace. Whereabouts is it ?