Different Server Name

Hi all,

I have a database created with MS SQL 2000 and I want to restore the database in SQL 2005 Express Edition. The problem is that both of the Sql servers are located on different computers so they have different server names. Is that possible to do it? I have tried to restore using the usual way and it failed. Thank you very much for your help.

Yes, you should be able to restore the database on a new machine (regardless of machine name). Are you hitting an error? If so, what does it say?

Thanks,
Sam Lester (MSFT)

|||TITLE: Microsoft SQL Server Management Studio Express

Restore failed for Server 'KID\SQLEXPRESS'. (Microsoft.SqlServer.Express.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 'Inventory List' database. (Microsoft.SqlServer.Express.Smo)

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

BUTTONS:

OK

The error message is something like above. Any idea how to solve that? Thanks a lot|||

Here's a thread showing how to work around this error:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=694693&SiteID=1

Thanks,
Sam Lester (MSFT)

|||

Hi Sam,

Thank you very much for the link. Now, I have understood what the problem is.