Sunday, July 29, 2012

Fix System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing database

When you restore your Database BackUp And get the the error :
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing  database. (Microsoft.SqlServer.Smo)

Solution :
-- ==============================

RESTORE DATABASE MyAppDB
FROM DISK = 'D:\MyBusinessDB.bak'WITH REPLACE


-- =================================


naadydev@gmail.com

No comments: