1

I am trying to create a copy of a SQL Server 2008 database under a new name on the same server.

I have physical access to the machine. I have tried to create a full backup and then restore that backup under a new name and I get an error from SSMS that "The backup set holds a backup for a database other than the selected database."

I have also tried doing a restore from database rather than restore from file and that did not work either.

What is the best way of making a full backup of a database and restoring the database with a new name?

Earlz
  • 1,019
  • 5
  • 13
  • 29

2 Answers2

0

When making that full backup, select to "Overwrite" your old backup or save it under a different name altogether.

Or you can use T-SQL:

RESTORE DATABASE YourDatabase FROM DISK = 'C:\YourDatabase.bak' WITH REPLACE

ADNow
  • 152
  • 5
0

Doh! The name of the database that you intend the copy to be must not exist.

I got it to work now [facepalm]

Earlz
  • 1,019
  • 5
  • 13
  • 29