Ok I am trying to fix my works database. the server died and they did a new install of the server and we they installed MS SQL server 2008 when we reinstalled it. I have made a database wich the old one was called V1 so I made the database V1 on the server and I try to restore the database from a backup we had wich was v1backup.bak and I keep getting this error "System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'V1' database. (Microsoft.SqlServer.Smo)" I am using SQL Server Management Studio to restore from backup.
I think the below link will help you to restore your database: http://blog.sqlauthority.com/2007/0...-a-database-other-than-the-existing-database/ Kailash