I have a client that has POS software called Restaurant Pro Express (RPE) from www.pcamerica.com.
RPE uses a SQL Server database.
Their old POS server had a hardware failure, but I was able to attach the hard-drive to another computer and recover the data.
However, my client doesn't seem to make backups very often – the last one is dated January 5, 2015.
I was able to copy the C:\Program Files\Microsoft SQL Server\ folder which contained the instance as well as all the data files – and has up-to-date information. The instance in the recovered Microsoft SQL Server folder was called MSSQL.1.
I installed the RPE software on the new computer and a SQL Server instance called MSSQL10_50.PCAMERICA.
The new computer is using SQL Server 2008 R2, while I believe the old computer would have been using SQL Server 2005.
I am not a DBA, especially when it comes to SQL Server.
- Is is possible to 'recover' the database from the 'raw' .mdf and .ldf files from the old computer to the new computer / SQL Server instance?
- If so, how should I proceed?
Best Answer
Please pay attention. The answer from Julien is correct. BUT if you attach the database to an SQL Server 2008 instance it will be upgraded! If the application can't handle SQL Server 2008 and needs SQL Server 2005 you're in trouble. Take an extra step and make a backup.
Furthermore you have to create the needed logins on the new server. You might want to attach the old master under a new name for looking up the details.