Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 restore failed for server 'my_server_name\sqlexpre

Author  Topic 

keekee
Starting Member

1 Post

Posted - 2011-02-11 : 12:51:21
I create a new database name (mynewSQL2005) and use *.bak file to restore into my new database.
I got an error as below. I am new in this field. Please help.

Restore failed for server 'my_server_name\SQLEXPRESS' (Microsoft.SqlServer.Express.Smo)

Additional information:
System.Data.SqlClient.SqlError: The backup set hold a backup of a database other then the
existing 'mynewSQL2005' database. (Microsoft.SqlServer.Express.Smo)

homebrew
Posting Yak Master

114 Posts

Posted - 2011-02-16 : 14:11:12
Maybe if you post the code you are using, someone will spot the error ? Maybe there's some kind of limitation with Express ?
Go to Top of Page
   

- Advertisement -