Restore QuickBooks Backups

Question:

How do I check to make sure I can actually restore my backup files?

Answer:

If you are using a local backup, I have a quick video explaining the process here.

If you are using QuickBooks online backup, use Web Restore to restore your latest online backup company file to a folder on your local computer.

Web Restore allows you to restore your backup files using Microsoft Internet Explorer 5.(x) and newer or Mozilla Firefox 2.(x) and newer. With Web Restore, you can access only the last successful backup performed.

To restore your Online Backup files:

1 – Create a folder on your desktop called "Test Restore"

2 – Go to the QuickBooks Online Backup Login page here

3 – Enter your Account ID and Password and click the Web Restore button.

4 – If prompted, install the ActiveX control.

5 – Follow the online instructions and locate the company file (mycompany.qbw) that you want to restore. Then, click Restore.

6 – Save the file to your "Test Restore" folder on your desktop.

You can take it one step further by testing the file in QuickBooks. Remember not to confuse the file with your current production company file. Delete the file from your "Test Restore" folder when your test is complete. It would be a good idea to test your backup every month.

If you are not using QuickBooks Online Backup, you can purchase a 1 GB or 10 GB service plan here

If you need more than 10 GB, use another online backup service such as Mozy or iBAckup.

Also, A QuickBooks company backup file {mycompany}.QBB, does not contain everything to fully restore your QuickBooks to full functionality. Features like Shipping Manager, Loan Manager and add ons are not saved in the QBB file.

Consequently, house all of your company files including add on data, in a dedicated folder then backup the entire folder to your online backup service. I have a detailed instructional video at http://lesmurphy.com/.

Are You Ready For QuickBooks Multi User?

Visit painlessquickbooks.com to find out.

Moving QuickBooks Company Files

Questions:

How do I move my company file from my laptop to the server and the server only has the database version of the install?

I have the same issue. I made a backup from ,my laptop of the company file what I’d been connecting to at work. I then restored the backup file to my laptop to have a working version while out of the office. Now i’d like to take that company file that I’ve changed which is on my laptop and put it back onto the QB Data Server for all to access as before.

Answer: Close QuickBooks on every computer that accesses your company files.

Make sure the Windows computer you are using is configured to "see" the file extensions of files. Rename the company file on the server share where your production file is located by appending a date to the file;

IE [company_name].QBW.[date] mycompany.QBW.2009jan11

Close QuickBooks on your laptop.

Browse to the company file on your laptop. Copy the company file on your laptop then paste it to the server share where you previously renamed the company file. DO NOT MOVE THE FILE. COPY THEN PASTE.

You will now have two files on your server:

mycompany.QBW.2009jan11

mycompany.QBW

mycompany.QBW becomes your updated production company file

Check your production file then change the name of the company file on your laptop.

You do not want to find yourself in the position of having many company files with the same names with different data in each file, on different computers. Get in the habit of thinking about using only one production company file, mycompany.QBW per company. Rename files to take them "out of production"

You will need to totally understand general Windows folder and file structure, including what extensions are, so that you know beyond a shadow of doubt "where" your files are located and "what" their names are. If you tend to loose files and create duplicates, moving production QuickBooks files around is not for you.

Are You Ready For QuickBooks Multi User?

Visit painlessquickbooks.com to find out.

QuickBooks Database Manager Stops Working

While on the QuickBooks Online Community the other day, I took the opportunity to answer a particularly difficult question concerning QuickBooks Multi User and Microsoft Server 2003 that has plagued systems people for awhile.

QUESTION:

I have the Database Server Manager running on a Windows 2003 server. It seems that when ever I use Remote Desktop to access the server, it causes the Database Manger to stop working. I have to physically go to the server, log into QuickBooks…change it to Single User mode… close out of it… go back in and change it back to Multi-User mode and exit the program. Then I start the Database Server Manager.. have it scan for company files and it’s working again.

Is this a setting I have missed that causes this to stop working?

Has anyone else experienced this issue before?

MY ANSWER:

“Is this a setting I have missed that causes this to stop working?”

You’ve probably not missed anything.

“Has anyone else experienced this issue before?”

I’ve repeatedly had this problem on Server 2003, to the point that I’ve developed a standard workaround.

You will need to configure this from a console session using either a keyboard/mouse/monitor, remote desktop using “%windir%\system32\mstsc.exe /console” or VNC to the console. Then, remember to always manage this server from a console session.

Use the “administrator” user to login to the desktop.

Remove or turn off any firewall software on the server.

Configure the server to automatically logon as the “administrator” user to the desktop using TweakUI or regedit.

Configure the desktop to go to a screensaver and be password protected on resume. This will lock the desktop after the wait time passes, securing your server.

Install a completely updated full version of QuickBooks to the server.

Open the company file then logon as Admin. Set QuickBooks to Host Multi-user access, and then close QuickBooks.

Restart the server, remove the keyboard/mouse, watch the monitor to test the auto logon to the desktop, and then remove the monitor.

Open QuickBooks on a client computer. Confirm that Host Multi-user access is turned off. Confirm that any firewall software is turned off. Then, open the company file to test network access to QuickBooks.

Your QuickBooks environment will stabilize.

If you are concerned about security, locking the desktop will secure the server’s administrator desktop. Remember to disconnect a console RDP session, not log off. Also, firewalls belong on your gateway to the Internet device. Your real-time anti-virus/anti-malware software on your client computers will deal with any security issues that might get past the hardware firewall on your network without having the local client computer’s firewall software turned on.

Are You Ready For QuickBooks Multi User?

Visit painlessquickbooks.com to find out.