Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Attach database is not working SQL SAP Business One

nikunjmehta2290
Participant

on ‎2024 Aug 14 10:49 AM

0 Likes
413

Dear all,

When I am trying to upload the .mdf file using option ATTACH into SSMS but it is showing error as per attached snap.  I have taken a backup from same SQL server and same SQL SSMS and try to attach into same instance but it is showing error.  

nikunjmehta2290_0-1723629033303.png

Regards,

Nikunj 

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
brendanbell
Explorer
‎2024 Aug 15 4:59 AM
When you are attaching the file, are your ensuring you rename this new database name. It will rename the file. If you are just simply attaching as the same file. it its clashing the existing database.

Accepted Solutions (0)

Answers (0)

Ask a Question