Attach database...

In 2008r2 after copying Northwind.mdf and Northwind_log.ldf to:

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

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:

40DF713EA32F9F3F8F3CB35148496FD3_ AND TRANSACTIONS (ADO.NET)\SAMPLES\UNIT9SAMPLE3\SAMPLE2SQLTRANSACTIONVB\BIN\DEBUG\NORTHWND.MDF    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.

Thank you.
AttachDB.png
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sagir87Commented:
hi


Catalog views return information that is used by the SQL Server Database Engine. We recommend that you use catalog views because they are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user-available catalog metadata is exposed through catalog views.

Note:
Catalog views do not contain information about replication, backup, database maintenance plan, or SQL Server Agent catalog data.

Some catalog views inherit rows from other catalog views. For example, the sys.tables catalog view inherits from the sys.objects catalog view. The sys.objects catalog view is referred to as the base view, and the sys.tables view is called the derived view. The sys.tables catalog view returns the columns that are specific to tables and also all the columns that the sys.objects catalog view returns. The sys.objects catalog view returns rows for objects other than tables, such as stored procedures and views. After a table is created, the metadata for the table is returned in both views. Although the two catalog views return different levels of information about the table, there is only one entry in metadata for this table with one name and one object_id. This can be summarized as follows:

The base view contains a subset of columns and a superset of rows.
The derived view contains a superset of columns and a subset of rows.

You can add those catalogs and clikc OK button.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.