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?