Click here to Skip to main content
14,336,236 members
Rate this:
Please Sign up or sign in to vote.
See more:
Restore database error in sql server 2005

How to restore database error

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'kannan\SQLEXPRESS'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'FinanceManagement' database. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
Posted
Rate this:
Please Sign up or sign in to vote.

Solution 1

The error message is pretty self-explanatory - you are trying to restore a database into a different database. Restore it into teh original database, and it should work fine.
   
Rate this:
Please Sign up or sign in to vote.

Solution 3

restore database databasename from disk='Path' with replace

Run this query.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100