Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
1
1106113077
September 10, 2019
Question

QB server manager questions

  • September 10, 2019
  • 1 reply
  • 0 views

Hi all, I have a customer (accountant) that works on hundreds of QuickBooks data files. He stores them out their server. Here is the issue, when he gets a data files (backup) from one of the customers, he restores it to the server. It always comes back with an error so he has been restoring the data files to the local computer, working on the data file and then creates a backup to the server. Not ideal because there are other users that need to access that same data.

 

Now, as I understand, the QB server manager runs every 24 hours.

 

So, temporarily, this is what I do to get them going;

I have them restore their files to the server. Each time they restore, it fails but really, it appears to restore properly.

They email me and I remote into the server and run the QB server manager. 5 minutes later, they are able to access all of those restored files.

 

Questions

  1. He can’t be the only one that is going through this issue so I’m guessing there ‘may’ be a better way to do this? If not…
  2. Can the QB server manager be changed to run let’s say run every 30 minutes?

1 reply

Aphylis
Aphylis
September 10, 2019

Hi @1106113077,

 

Quickbooks Database Server Manager can run 24 hrs depends on the server if it's kept opened. As for the file that one of the user saved on the server where you had the problem on opening, we have to make sure that the company file was saved on one of the scanned drive of your Database Server Manager. 

 

To troubleshoot the problem we can try to Restart Database Server Manager.

  1. Open QuickBooks Desktop on your server computer.
  2. Go to the File menu. Then select Open or Restore Company.
  3. Select Open a company file. Find and open your company file. Then select Next.
  4. Select the Open file in multi-user mode checkbox, then select Open.
  5. Log in to your company file.
  6. Go to the File menu and select Close Company/Log off. This closes your company file on the server.
  7. Open the Windows Start menu.
  8. Type “Database” into the search and open QuickBooks Database Server Manager.

If the issue still persist after restoring you can contact Quickbooks support team so a representative can check on the setup and also on how the company file was saved on the server. 

 

Let me know if you have any other question. 

1
1106113077Author
September 10, 2019

Thanks for the reply but I still have the two questions.

 

What is the process to accessing multiple files during the day as the accountant gets them BASED on the fact that the QB database server manager only runs once a day?

 

This has been ongoing for quite a while now, I’ve contacted QB support and they told me that the only solution is do what we are currently doing, re-run the QB DB server manager scan each time we restore a file to the windows server.

 

Just to be precise in what I’m doing, here is the exact process

  1. Retrieve customer backup data file from USB key and copy it to C:\Temp
  2. Open up QB 2019 and open up the backup file and restore to Q:\QB_Data
  3. After the company file is restored, QB throws an error: -6000,-83
  4. Acknowledge the error, Ok
  5. Remote into the windows server and run QB dB manager and start scan
  6. After the scan is complete, switch back over to the workstation that we are working on
  7. Open the company file – no issues.

That is the process that we go through and it works.

This can’t be the way things work but it appears to be the way it works here.

That is why I’m asking the two questions.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement