question

wkilany avatar image
wkilany asked

error when attache database

Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\PMDB1_fs_doc.mdf". Operating system error 2: "2(The system cannot find the file specified.)". A file activation error occurred. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\PMDB1_fs_doc.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation. Could not open new database 'PMDB1'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)
recovery
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I have only dat and log file and i dont have PMDB1_fs_doc.md
0 Likes 0 ·
What's the statement you're trying to run?
0 Likes 0 ·
Waqar_lionheart avatar image
Waqar_lionheart answered
dont you need the mdf file to connect to database. AFAIK, you cant attached the db without mdf
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wkilany avatar image
wkilany answered
when i try to attach i got that error Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\PMDB1_fs_doc.mdf"
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.