move SQL 2005 DB to SQL 2008
Posted on 2009-04-09
I have two SQL servers running, one 2005 the other 2008. I am in the process of retiring the 2005 server and need to move my db's over to the 2008 server. I tried doing a backup in 2005 and restore into 2008 but get errors when I try this. The error is as follows:
"Restore failed for Server 'SQL'. (Microsoft.SQLServer.SmoExtended)
System.Data.SqlClient.SqlError: File 'F:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\PJIPro.MDF' is claimed by 'PJIPRO_RMHanover_Log'(2) and 'PJIPRO_RMHanover_DATA'(1). The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo)"
The db is called PJIPro. I checked the path and the data/log files are not there.
I'm not very well versed in SQL so any help I can get would be great. I've got a number of db's to move, none very large, if there is also a way to batch move them I'd love to know how.
Thanks for the help.