A client of mine was running a software package called Console Gateway that used a SQL express 2008 r2 database and the server's mainboard died.
I've installed a new server that is 64-bit and have installed SQL express 2008 R2 64-bit. And have copied across all of the important data from the old hard drive.
How can I open/attach the database (I have the entire directory it resides in) on this server to use with the Console Gateway software?
I'm not too familiar with Microsoft SQL...