I am running MSSQL Server 2012 RC 0.
I am using the management studio to create a backup of a database, and then restore it on the SAME server, but with a different database name.
I can create the backup fine, but when I go to restore the backup, I enter the new name of the database that I want it to create (which doesnt exist).
I then get an error saying:
"Restore of database 'newdatabasename' failed....... Exclusive access could not be obtained because the database is in use.
I know there is plenty on the internet about this, but it is more geared towards restoring over the SAME database.
Which database is it referring to? The old one? I can't see why it would refer to the old database as I am restoring from a full backup file. The new database isn't even created yet so I also can't see why it would be referring to that one.
Any help appreciated!