Resptre failed for server 'my_server_name\sqlexpress'

• moongeegee

  Grasshopper

  Points: 12

  More actions

  February 11, 2011 at 9:44 am

  #388840

  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)

• ABAS101

  SSCommitted

  Points: 1894

  More actions

  February 11, 2011 at 12:20 pm

  #1285865

  Can you provide your restore script?