What I want to do is backup database <b> on server B and restore as database <a> on server A, database <a> already exists. what I did is
1. Backup database <b> on server B and copy the backup to server A.
2. DROP database <a>
3. restore
RESTORE DATABASE database <b>
TAKEN AT timestamp
ON D:\xxxx1,D:\xxxx2,D:\xxxx3
DBPATH ON D:\
INTO database <a>
NEWLOGPATH log path
WITHOUT ROLLING FORWARD
WITHOUT PROMPTING;
I get the error above however if I change the INTO line to
'INTO database <c>' a databse name that does not exists on server A it works fine....