How to attach Database during Master DB Corruption?

How to attach Database during Master DB Corruption?

Steps to attach Database during Master DB Corruption:

The steps for attaching  the database during corruption  are given below -

  1. Click the C:\ drive and open Program Files.

     2. Select the Microsoft SQL Server folder.

     3. Open the MSSQL.1 folder.

     4. Open the MSSQL folder and select the DATA folder..

       5. Select the master and mastlog files and delete it.

      6. Go back and select the folder Template Data.


       7. Select the master and mastlog files and copy the files.

        8. Paste the files in the DATA folder again.

       9. Close the screen.

Now master db is fresh and you are about to attach the GoFrugal databases to it ,so you can be able to work with POS.

 10. Right click on the GoFrugal RPOS6 icon on the desktop

 

      11. Click Properties.

     12. The GoFrugal RPOS6 Properties screen is displayed.

13. Click on the Find Target button.

14. The GoFrugal RPOS6 Application path is displayed.

 

15. Open the DBSurgeon 

   

16. The DBSurgeon screen is displayed.

 

17. Click the button Attach ldf & mdf.

 

18. The Attach database data & log files screen is displayed.

  • Database Name, enter the database name for which the selection is given. For example, now here the database name will be MEDISHOPDB 

  • MDF File, you can use the browse button to browse the mdf file of medishopdb from C:\Program Files\Microsoft SQL Server\DATA.

  • LDF File, you can use the browse button to browse the log file of medishopdb from C:\Program Files\Microsoft SQL Server\DATA.

19. Click the Attach DB button.

 

20.  In the DBSurgeon screen, a message 'medishop database attached' is displayed. Click OK.

 

21. Now enter the database name : rposauditdb and click Attach DB button.

  • Database Name, enter the database name for which the selection is given. For example, now here the database name will be rposauditdb 

  • MDF File, you can use the browse button to browse the mdf file of rposauditdb from C:\Program Files\Microsoft SQL Server\DATA.

  • LDF File, you can use the browse button to browse the log file of rposauditdb from C:\Program Files\Microsoft SQL Server\DATA.

22. In the DBSurgeon screen, a message 'rposauditdb database attached' is displayed. Click OK.

23. Now enter the database name : rpostracdb and click on Attach DB button.

  • Database Name, enter the database name for which the selection is given. For example, now here the database name will be rpostracdb.

  • MDF File, you can use the browse button to browse the mdf file of rpostracdb from C:\Program Files\Microsoft SQL Server\DATA..

  • LDF File, you can use the browse button to browse the log file of rpostracdb from C:\Program Files\Microsoft SQL Server\DATA.

24. In the DBSurgeon screen, a message 'rpostracdb database attached' is displayed. Click OK.

 

25. Close the DBSurgeon screen.

 

Now it is ready to use. You can access and start your work as the fresh one.

    • Related Articles

    • How to Archive Audit Report Data on your RPOS6 DB (RposAuditDB)?

      Right-click the GoFrugal RPOS6 icon. Click Properties. The GoFrugal RPOS6 Properties screen is displayed. Click Open File Location. The GoFrugal RPOS6 file location folder is displayed. Double-click the ArchiveData.exe icon. The Archive Database ...

    • How to Archive your Transaction Data from your RPOS6 DB (Medishopdb)?

      Steps for Archive Data - Archive Transaction (Medishopdb (Production Live Data)) Right-click the GoFrugal RPOS6 icon. Click Properties. The GoFrugal RPOS6 Properties screen is displayed. Click Open File Location. The GoFrugal RPOS6 file location ...

    • Steps to follow in Item Master Configuration to create a weighable item for bar-code generation

      The Item Master is configured based on the followings: Weight - Based on the weight of the items. Count - Based on the quantity/count of the items. Steps for Item Master Configuration (Based on the Weight) Click Inventory -> Masters -> Item Master or ...

    • How to view the Archived database?

      Viewing Archive Data Steps to View Archive Data Click Tools > Business Intelligence > Load Archive. A message Do you wish to Change to ARCHIVE Database? is displayed. Click Yes. The Archive Database screen is displayed. Note: In the Archive Data only ...

    • What is a Nutrition master?

      Nutrition master is mainly used on nutrition shops for adding nutrition ingredients like calories,Fat,Protein,Sugar,Carbohydrates,Dietary fibre,So that it will allow to view the ingredient details on bill print as well as barcode print.In recipe ...