We've had a harddrive on a PC go belly-up. We were able to partially get it up and running, enough to get files off, but most of the services (including SQL-related services) cannot run. Therefore, we cannot connect via Management Studio.
We do have a data backup, but it's a little old (it's a non-critical bunch of data).
Is there any way to restore a database on a new machine with just the database files?
MSDN for attaching a database (MDB File)
In SQL Server Management Studio Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine, and then expand that instance.
Right-click Databases and click Attach.
In the Attach Databases dialog box, to specify the database to be attached, click Add; and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the .mdf file of the database; for example: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_Data.mdf
Optionally, to specify a different name for the database to attach as, enter the name in the Attach as column of the Attach Databases dialog box.
Optionally, change the owner of the database by selecting a different entry in the Owner column.
When you are ready to attach the database, click OK.