How to attach .mdf file sql server 2008 ?

Question

0.00/5 (No votes)

See more:

For following error occur
1. To upgrade a full-text catalog,click add catalog,and locate and select it. Full-text indexes will be imported, based on the Full-Text Upgrade Option.

2. Dialog box show error message

1.IF you are certain that you have added all the necessary full-text catalogs, click ok. To add more catalogs, click cancel
2. An error occured when attaching the database(s). Click the hyperlink in the message column for details.

please help me remove this error occurs.

thank you.

Posted 10-Jan-12 18:22pm

arulbaskar

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2012-01-10T18:27:00

Solution 1

These two resources could help you
http://msdn.microsoft.com/en-us/library/ms177429%28v=sql.100%29.aspx[^]
http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/[^]

Posted 10-Jan-12 18:27pm

Abhinav S

Ganesan Senthilvel · Answer 2 · 2012-01-10T18:32:00

Solution 2

You can attach mdf file to SQL Server using the below code:

SQL

CREATE DATABASE TestDb ON
( FILENAME = @'C:\MyFolder\TestDb.mdf')
FOR ATTACH
GO

In reference to your question, itz advisable to remove the existing full text catalog and adding a new catalog with the same name. When upgrading a server instance to SQL Server 2008 R2, the user interface allows you to choose three upgrade options: Import, Rebuild and Reset.

Posted 10-Jan-12 18:32pm

Ganesan Senthilvel

Comments

arulbaskar 12-Jan-12 0:58am

I am executed this code
CREATE DATABASE TestDb ON
( FILENAME = 'G:\DB\smsdb_Data.mdf')
FOR ATTACH
GO
For following error occurs
Unable to open the physical file "G:\DB\smsdb_Data.mdf". Operating system error 5: "5(Access is denied.)".

how to remove existing full text catalog please step by step process.

Thankyou

sravani.v · Answer 3 · 2012-01-10T19:55:00

Solution 3

Refer these links:

http://www.kodyaz.com/articles/sql-server-attach-database-mdf-file.aspx[^]

http://msdn.microsoft.com/en-us/library/ms165673.aspx[^]

Posted 10-Jan-12 19:55pm

sravani.v

Nagi Setty Akuthota · Answer 4 · 2014-11-12T03:16:00

Solution 6

Change the permission levels to FullControl for that *.mdf file, which ever you trying to attach the database.

Posted 12-Nov-14 3:16am

Nagi Setty Akuthota

vijaysutaria · Answer 5 · 2012-07-04T18:54:00

Solution 4

Run the same thing by using "Run As Administrator" option

Posted 4-Jul-12 18:54pm

vijaysutaria

Comments

narayana1984 20-Jul-14 13:42pm

thank u so much it worked

NguyenVan Tu 26-Jul-14 10:25am

thank u