How do I import a Sql 2005 database so that I can read it using Sql 2008 using SQL Server Manager?? I have a database file AddressBook.mdf that is a database file created with SQL Express 2005 and I would like to import it onto my SQL 2008 server. I tried attaching the database file using SQL Server Management Studio but it does not work. It is looking for a AddressBook_log.ldf file.
So how do I get SMS to import the older database. I want to use the older database to work through a visual studio example that is in my book but I can't get my Sql 2008 server to recognise the older Sql 2005 examples. I would rather not load Sql 2005 if I can avoid it.