Error: 5133 when i attach database!

Question

Error: 5133 when i attach database!

ngochoang297

SSChasing Mays

Points: 628
More actions
January 13, 2014 at 7:41 pm

#284445

TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Attach database failed for Server 'NGOCHOANG-VAIO\BMSSERVER'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&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.Express.ConnectionInfo)
------------------------------
Directory lookup for the file "D:\BMSMoi2013\DATA2013\BMS_2013.mdf" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft SQL Server, Error: 5133)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5133&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Screen :
Pls help me!
Email : ngochoang297@gmail.com
Skype : Robertsnguyen [Smile]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Montana Life Right there with Babe Points: 720 More actions · Answer 1

Your screenshot is a bit blurry. Are you sure the current file path selected for the MDF is valid and the file is in that directory?

Mike

How to Post Performance Problems[/url]

How to Post Best Practices[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

The path you've specified for the mdf file doesn't exist

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass