restore thePhile database with 2005 SQL Server
Hello,
Using 2005 SQL Server Developer Adn.
Original Wrox zip file contains with "thephile-database-backup" database file - no .bak extension.
I renamed it as "thephile-database-backup.bak" and copied it into
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
folder.
By using 2005 SQL Server Management Studio, I created "thePhile" database under database folder.
and right clicked on "thePhile" > task > restore > database > then
selected "from device" added
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\thephile-database-backup.bak
I am getting following error:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'thePhile' database. (Microsoft.SqlServer.Smo)
Please, help
Jim
|