Tag Archives: SQL Data Base Backup
How to resolve error when attaching a database in SQL Server
Introduction: One of the common Errors while attaching a .mdf file for restoring Data is as follows: An error occurred when attaching the database(s). Click the hyperlink in the Message column for details. The detailed message is as follows. Step 1: Right, Click on the .mdf that you want to attach and click on Properties. Step 2: Go to Security tab and give Full Control to all Users and Groups by clicking on Edit. Click on the Check Box under Allow section for Giving Full Control to all Users and Groups. Step 3: Right-click on the Main Folder containing your .mdf file and go to the properties section. Deselect the āRead Only Optionā in āGeneral Tabā and click on Apply. Step 4: Go to the āSecurity Tabā and give āFull Controlā to all āGroups and User Namesā as shown in Step 2 and click on Apply. Select āApply changes to this folder, subfolder and filesā option and click on āOkā. Click on āOkā to apply all the changes. Step 5: Now go to SQL and Attach your .mdf file Again and your DB will be attached to the Databases folder and you can access it. Check out my other blog here https://www.cloudfronts.com/blog/dynamics-nav/performing-update-operation-in-microsoft-dynamics-nav-through-integration-in-tibco-cloud-integration/