Sql 2012 file attach

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

I detached one sql 2012 DB and moved the file table folder and mdf and ldf files to another drive in the same machine. Now I need to attach the files
but got error
Please help

What I have tried:

I did the below steps
1. database -> right click ->attach
2.Clicked add button and selected the mdf file
3.clicked ok
It shows the below error
TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'SQL7\MSSQLSERVER2012'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2218.0+((SQL11_RTM_GDR).120612-1251+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Unable to open the physical file "D:\data\DB\MyFileTable". Operating system error 2: "2(The system cannot find the file specified.)".
A file activation error occurred. The physical file name 'D:\data\DB\MyFileTable' may be incorrect. Diagnose and correct additional errors, and retry the operation.
Could not open new database 'MYDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 5120)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2218&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

D:\data\DB\MyFileTable was my previous path of the DB files. I now moved them to E drive.

This DB contains MDF , LDF files in the same path and along with that I have one folder to keep file table too in the same path. But previously the path was in D and the error message shows that it is still checking D drive for the file table.I moved the file table folder to D drive and MDF and LDF in E Drive itself and tried.Then it worked fine. But i need to move the file table also to E drive before attaching.

Posted 20-Oct-16 3:06am

Member 10112611

Updated 24-Oct-16 1:00am

v4

Add a Solution

Comments

Member 10112611 24-Oct-16 6:59am

This DB contains MDF , LDF files in the same path and along with that I have one folder to keep file table too in the same path. But previously the path was in D and the error message shows that it is still checking D drive for the file table.I moved the file table folder to D drive and MDF and LDF in E Drive itself and tried.Then it worked fine. But i need to move the file table also to E drive before attaching.

1 solution

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)

Suvendu Shekhar Giri · Answer 1 · 2016-10-21T11:31:00

Quote:
When you attach a database, all data files (MDF and LDF files) must be available. If any data file has a different path from when the database was first created or last attached, you must specify the current path of the file.
When you attach a database, if MDF and LDF files are located in different directories and one of the paths includes \\?\GlobalRoot, the operation will fail.

Attach a Database[^]
or just try copying file to its old location and try again.

Hope, it helps :)