A2.107 : How to attach Database file from Accounting or POS Backend
Question :
I have copied raw database from old PC, because it already can’t do normal backup action. How can I do restore or attach the database to new computer? Now my PC is not yet installed with Microsoft Management Studio
(https://wiki.autocountsoft.com/wiki/Others:_How_to_attach_Database_file_from_SQL_Management_Studio).
Solution :
If you are yet to install Microsoft Management Studio, try to use AutoCount Accounting or POS Backend attach. Make sure your files access right is everyone with full control.
1.If not please Right click your .mdf & .ldf files > Properties
2.Go to Security tab > Advanced > Change > enter Everyone > Check Names > OK
3.Click on Add
4.Click on Select a Principal > enter Everyone > Check Names > OK
5.Tick Full control > OK > OK
6.Login Accounting or POS Backend > File > Manage Account Book
7.Click on Attach Account Book > Attach Database File
8.Fill in ‘.\A2006’ on Server Name: column > click Browse under Physical DataFile > Find your correct .mdf file > Open > OK
9. Fill in ‘.\A2006’ on Server Name: column > click Get Available Databases > select your new DB > OK > OK
Related Articles
A2.126 : How to configure POS B attach POS A database
Question : How to configure POS B attach POS A database? Solution : For Pos 3: You need to configure settings at POS B. Open AutoCount POS Database Configuration Alternatively you may find database configuration application at C:\Program Files ...A2.125 : How to restore Frontend database on existing PC with POS
Question : One of my cashier need to send for repair. How can I temporarily move all data to a backup PC? Solution : First of all, you need to have the latest backup file of existing company. Then go to the target machine (which POS/F&B software is ...A2.118 : How to import voucher no to Pos Backend?
Question : I have created an Excel template of Voucher no. , how to import it to POS/F&B? Answer : Login POS 5.0 Backend > Point Of Sale > Maintenance > Voucher Maintenance Click on New to create New Voucher ID, and click on Import tab. Click on Load ...UBSA1.13 : Access UBS (Accounting): Back up the company database
Description How to create a backup of the company database. Environment Access UBS (Accounting) Solution To create a backup of the company database, follow the below steps: 1. Login to Access UBS Accounting. 2. Select Company. 3. Select File, click ...UBSA1.171 : Access UBS (Accounting): How to solve error on Database Optimizer
DescriptionHow to solve error on Database Optimizer for UBS Accounting & Billing Data optimizer issue in inventory EnvironmentAccess UBS (Accounting) Solution How to solve the error on Database Optimizer in Accounting: Open the company database, ...