In 2008r2 after copying Northwind.mdf and Northwind_log.ldf to:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSER
I attempted to attach this database from management studio. I am getting a message in the process stating:
If you are certain that you have added all the necessary full-text catalogs, clcik OK. To add more catalog, click Cancel. (Please see the attached image)
Q1: Could you please write a line or two about what catalog means here?
Because I am not sure, so when I click OK, the database shows up like:
496FD3_ AND TRANSACTIONS (ADO.NET)\SAMPLES\UNIT9SAM
F in the management studio.
but I expect it to show just: NORTHWND
Q2: What action do I need to take to remedy this?
Q3: Is it possible that this version of NORTHWND.MDF I have is not compatable with 2008R2?
This because I have attached databases before without this kind of issue to deal with.