I'm helping a friend try and restore a SQL Server database. The hard drive crashed that had his Server 2003, SQL Server 2005 and databases on it. So far he has reinstalled Server 2003 Enterprise and has the MDF and LDF files from the database.
How can I tell which updates were applied to the server hard drive that crashed? We still have the hard drive that crashed, and can attach it as an external USB drive using a USB enclosure, we just can't boot off the old hard drive. I'm trying to get the new SQL server install on the same patch/update level as the old so I can attach the mdf and ldf files and get this up and running again.
Are there any log files on the crashed drive we can access to find out which version/patch/updates of SQL Server they were using before?