All Orders uses a SQL Server database to store all of your company’s data. Backing up the database properly is critical to recover your data in the case of a disaster. It is the only file that must be backed up as all company data for All Orders is stored in the database.
A SQL Server database consists of both an .MDF file (the data file) and an .LDF file (the log file). These are the live database files and are not typically backed up. Instead, a single .BAK file (SQL Server backup file) is created which includes both the .MDF and .LDF file and then the .BAK file is backed up (backing it up offsite is the best option).
A .BAK file can be created from All Orders by logging in as the admin and going to the File menu and clicking the Backup menu selection. A message will show you where on the server (or whichever machine the database is located) the .BAK file was placed. If this folder is already part of the backup set for your automated offsite backup software (Mozy, Carbonite, iBackup, Dropbox etc…) then you are good to go. Simply click the Backup menu selection as often as you want to backup your All Orders database. If the folder where the .BAK files are being placed is not being automatically backed up by a backup service, be sure to make a copy of the .BAK file to a flash drive or, at the very least, another computer in case of a disaster in which the server experiences hard drive failure.
We here at Numbercruncher use SQL Server databases for our own purposes internally and have developed an application to automatically create .BAK files on a regular basis, compress them, and place them in a specific folder for our automated backup service. This removes the need to manually click Backup in All Orders and will ensure .BAK files are created automatically. You can download this application along with instructions on using it from our utilities page located here:
http://numbercruncher.com/t-utilities.aspx
Another option which would eliminate the need for manually creating .BAK files to backup is to use an offsite backup service which has special tools for backing up live SQL Server databases. One such example is iBackup which offers a plug in for backing up live SQL Server databases. More information is available on their website @ http://www.ibackup.com/online-backup-sql-server/ .
-
- Paying Your Maintenance and Purchasing Additional Services
- QuickBooks Online and All Orders
- QuickBooks Merchant Services
- "Error 549 unable to return object".
- How does the New Quantity Count work?
- What 'Cost' is used on the Bill of Materials?
- Merging Item in QuickBooks - All Orders
- How to buy inventory on a credit card?
- How to assign time to a work order
- I don't want All Orders auto-fill a sales order
- How do you remove all locations except HQ
- How to do you copy or duplicate a sales order or purchase order?
- How do you restrict items being added to an existing purchase order.
- How do you turn off sync on startup
- How To: Put multiple ship dates for line items on a Sales Order
- How to restrict users to a particular location
- Printing blank or extra page
- After I create the ship doc in NC, what do I have to do for it to sync to QB or does it do it automatically?
- Why will the Count not finalize?
- Vendor consignment inventory
- How to run a script in All Orders
- Using Enhanced Inventory Receiving in Quickbooks with All Orders
- Sales order list not showing sales orders just entered
- Importing Sales Orders from QuickBooks with Multiple Addresses
- All Orders Mobile - Error: Cannot connect to web services
- Error - Violation of UNIQUE KEY constraint IX_tblDependency
- There was an error when composing an address in "". QuickBooks error message: There is not enough address lines to compose the address. Please rearrange the individual fields, so that they can fit in the 5-lines block.
- Error: User X is currently syncing. Please try again when that user has completed syncing.
- The validate record has been updated at the same time by another user. This save has aborted.
- "Method '~' of Object '~' Failed
- Setting up default payment gateways per customer
- Error 5: Invalid procedure call or argument when opening All Orders
- Setting up All Order to export reports to All Orders Web
- Cannot log into my All Orders Web or Mobile user
- Which Bins/Lot/Serial #s are chosen when auto filling on Ship Docs or auto picking on Work Orders?
- Quickbooks Sync Error : This Customer already has job information.
- Shipping complete
- Sales order approval
- Error 1911 Could not register type library for file AOLib6.dll
- Using the TAB key
- User Authentication Error when processing a credit card
- Object "XXXXX-XXXXXXXXXX" specified in the request cannot be found
- Using the Scan box with No Scanner Option
- Installation
- Welcome
- Linking QuickBooks custom fields to All Orders
- How to Add Fees to a Sales Order
- Invalid File Name error when opening All Orders
- Synching Transactions to QB
- Change the date on the Count Sheet
- Sync Error on Account Type - UK QB
- How does NumberCruncher Handle Sub-Contractors/Processes?
- An internal QuickBooks error occurred while trying to access the QuickBooks datafile
- How can I see Inventory quantity or status by bin, lot or serial number
- How does a Payment panel show up in a Sales Order or Ship Doc?
- How does currency or currencies work in All Orders.
- How to clear all transaction in the database
- HOW TO - Opening All Orders 6 client without QB (additional tips)
- When I press Fill on the sales order, my quantity (on the ship doc) increased when I scan my items. How can I fix this?
- Excluding bins when picking a work order
- Why does my inventory go to the default bin?
- How to prevent freight from being taxed
- All Orders Web ( AOW) - How can I change the logo or picture
- SummaryGroup 'XXXX' doesn't exist.Please check Control 'XXXX'
- Inactive Component in a BOM and Work Order- How to Replace?
- AOMobile Settings
- Entering BOM components as percentages
- Non US Customer Tax Settings Not Visible
- Please wait while Windows configures ...
- All Orders Mobile does not scan my barcodes properly
- Run Time Error 339 - Component FM20.dll
- Backing up your All Orders database
- Automation error library not registered" when trying to send an email
- AO Web Address by name
- Linking Work Orders and Sales Orders
- QuickBooks report that shows average costs calculations
- Use Individual Line Discounts To Total The Order Level Discount - Advanced Sales Order Preference
- Cannot log into All Orders on some machines
- Error:Can only add items that were ordered
- CreditCard Processing- Difference between Authorize and Capture
- Database Failed To Backup After Update
- Error- The specified user is already logged in
- Invalid use of null or Invalid procedure error when posting a transaction to Quickbooks
- The integrated application has no permission to access personal data
- Main Menu and Toolbar
- How do I change the default printer for All Orders
- Error -2147220955: The given object ID "" in the field "list id" is invalid
- Updating C.R.M
- Sharing All Orders data with business intelligence and analytics systems
- Preparing your information
- Planning
- "QuickBooks Dividing Date" ERROR
- Error 3631:Violation of PRIMARY KEY constraint 'PL_tblitemLot'. Cannot insert Duplicate Key.
- All Orders Inventory Valuation and Ledger ( Rerecord )
- Reorder Points being deleted or overwritten
- Using FedEx Ship Manager with All Orders
- Settings up Gmail In All Orders
- Document are being duplicated in Quickbooks
- SQL Server 2016
- Error 549: The currency of the account must be either in home currency or the transaction currency
- Active X error after install
- Average Cost appearing in AllOrders seems too large or just wrong
- AO-->QB sync Order
- Error -2147217913: The conversion of varchar data type to a datetime data type resulted in an out-of-range datetime value
- Rerecord Stops Working
- UPS WorldShip - Integrating with AllOrders
- Maximum # of licensed users are already logged in
- Understanding Quantities in All Orders
- User is already logged in
- Column Width Wont save on Lists
- Making Locations/Bins Unavailable
- Adding Costs to a Receiving Doc
- Why should we use Purchase Orders?
- Setting up Part Numbers, Product Codes or SKUs for InventoryItems
- Report does not show all data
- Item is on list but not on sales order or purchase order
- Importing shipping addresses from Excel
- How to use the work order list filter
- How to sync manufacturing part #.
- How do add class per item on an invoice
- How do I remove HQ locaton
- How to change the display on the Item Drop Down
- How to put a hyperlink in a report.
- I created a transaction (e,g, Sales Order) but I cannot see it on the list.
- I get duplicate serial or lot number error but I deleted the transaction that used it.
- Adding to dependencies to existing orders.
- Class Not Registered or ActiveX Component Could not Create Object when trying to open All Orders
- User Access Violation
- How to add a Style name to a Sales Order or Quote?
- Quantity Differences Between Valuation Report and Inventory Movement or Screens
- How to change the Company Address in Reports
- Why is QB QOH and Quantity different on the Item List.
- Transaction (Process ID 60) was deadlocked on lock
- How to Limit SQL memory usage
- Control number of labels - Advanced.
- All Orders Web ( AOW) - Can I change the color scheme to match my companies?
- Exclude Checkbox in Reports Filter
- Blanket orders and multiple ship dates
- Quantity Ordered on a Purchase Order Rounding
- Installing AOWeb All Orders Web on 64 bit server with SBS Sharepoint Exchange
- List crashes or gives a pointer error
- Purchase Order does not print i.e., prints a blank PO
- ShipRush UPS Account Registration Failed
- Reports are very slow or cause the system to hand or become non responsive
- ShipRush Error - MSFLXGRD.OCX not found
- Access Denied - APPLIES TO WINDOWS 7 MACHINES OPERATING AS THE SERVER
- Hosting All Orders on a Dedicated Server
- Manually Controlling How All Orders Synchronizes Currencies And Exchange Rates
- Foreign Addresses are incorrect after being entered correctly
- Script to add items with zero quantity to Count
- Shiprush Error - Connecting SSL Unable To Post INTERNAL
- Access Violation Error when shipping from ShipRush
- winmail.dat email attachments
- Converting All Orders from V3 to V6
- The file is not attached to the server--or-- Database Failed to Restore
- Why are the quantities different in QuickBooks and NumberCruncher.
- Invalid use of NULL
- Cost and Foriegn Exchange Rates
- Shipping methods - All Orders will not let me edit, make inactive, or delete
- Hot Keys & Shortcuts
- Doc already exists in Quickbooks with a matching reference #
- Error 2018 Page Margins too large when running reports
- There has been an internal error when processing this request when syncing or sending a transaction to Quickbooks
- BOM Revisions
- What is a Rerecord?
- How can I find a list of BOM's that contain a specific component?
- Emails sent from Order Time have warnings associated with them that they might be spam or phishing
- Why are my Previous YTD totals incorrect?
- Synching an Assembly (BoM) between AO and QB
- How do you give an advance payment to a vendor?
- Reports are not showing all of the pages/data
- Medical Device Excise Tax
- Why are inventory quantities negative?
- What is a Bill of Materials?
- This application has not accessed this QuickBooks company data file before
- Non-inventory items have no description or prices
- Qty on Order but no PO's or WO's exist
- Number of packages on ship doc equals quantity
- Inventory Valuation
- Can you process more than one sales order at a time.
- Importing units of measure
- Error 339 ExComboBox.dll or Module Failed to Load Error
- Error while creating step, converting string to datetime
- How do you add an Item to a count
- How to change a serial or Lot #.
- How do you show a column on a list
- How is FIFO applied in All Orders
- When do transactions hit the All Orders Ledger?
- Can I assign one item number with multiple pricing detail?
- When you add a price level in Number Cruncher, how does it get added in QB? It seems that when you synch, the new price level doesn?t appear in QB.
- How to find your company files (config files) and error logs
- How BOMs and Work Orders work with Subcontractors
- On Backups in AO and on System Backups
- Off-Site Backup System
- How do I include EMPLOYEE costs?
- Handling the Costs of Goods Sold account. How certain conditions may impact behavior and WO components
- Extra digit in barcode (Check Sum Digit)
- How do I close, void or clear a sales orders
- Token List for Custom Messages
- This application is not allowed to log into this QuickBooks company data file automatically. The QuickBooks administrator can grant permission for automatic login through the Integrated Application preferences.
- Value Adjustment error when sending a Bill (must be positive)
- Error when entering shipping or freight amount.
- How to create a System DSN / ODBC Connection for Microsoft SQL Server
- PO's not syncing
- QuickBooks Sync Error Messages
- All Orders Solidworks Integration
- Transaction must be positive when sending a bill to QB
- When opening Shiprush from All Orders for Postal Service USPS shippig the screen is wrong and missing things
- Approved Label Printers
- Installing the All Orders client silently / Network Installation
- SMTP Email Error Messages
- Script to Sync Barcode field from QB
- Unknown error when sending a Europian customer to Quickbooks
- How to force task schedule to run an app as 32 bit INTERNAL
- error 1327- invalid drive ( when installing)
- Costing in All Orders
- What date is used when a work order is finished.
- Error 5707 Set device name failed. Invalid printer device name.
- Tips for speeding up All Orders
- How can I find out what my inventory stock quantities were as of a specific date?
- Error 2147220955: Quickbooks found an error when parsing the provided XML text stream.
- Entering Trial or License Codes
- Using Batch Sizes when entering Bill of Materials
- Error Message - "Cannot Start QuickBooks"
- The specified name is invalid or of the wrong type
- The Transaction Log for Database 'DB name here' is FULL due to 'NOTHING'
- Error: -247467259 error-cannot open database login failed
- CRM- Error 500
- Linking my All Orders Sales Order Number to the Invoice in QB
- Items not showing on PO
- Email error- Property is Read-Only
- Errors using Excel / Office 2010 and higher or sending email from Outlook 2010 and higher
- Error During Handshake when processing a credit card
- This feature is not enabled in this version of QuickBooks
- There is an invalid reference to a parent *.* in the Bills list. Quickbooks error message: Invalid argument. The specified record does not exist in the list.
- Sync Error Message: Customer, Item, Vendor NOT FOUND in the list or Invalid Argument
- How to perform a Location Transfer
- Setting up SMTP Email with Go Daddy GoDaddy
- Error -2147217913: The conversion of char data type to a datetime data type resulted in an out-pf-range datetime value
- Syncing Tracking Number to QuickBooks
- Using Entry Forms & Editors
- How To Move Your Database From One Server To Another
- Synchronization options
- Initial Synchronization
- Error 2147024882 - Not Enough Storage is available to complete this operation
- The "Begin Session" method has not been called or did not succeed. Item: Save
- How to install an All Orders patch
- All Orders Capacity Planning
- How to Track production processes/steps that are done by 3rd Party Vendors
- Why is AO average cost different from QB?
- How to Change your Logo in AOW
- The min quantity must be less than the max quantity
- Error- Violation of UNIQUE KEY -- AK_OpenDocs
- Quickbooks error message: This list has been modified by another user.
- Cannot edit the quantity directly because a sub form has more than one entry
- Sync errors W/ QuickBooks Online ( QBO)
- Setting up Auto Sync for All Orders
- Crediting credit cards not linked to prior captures/sales using the Authorize .Net Payment Gateway
- Generating Vendor RFQs
- Orders with kits or configurations
- Shipping from multiple locations
- Creating Ship Docs
- Creating a New Sales Order
- Moving REPORTS from one database to another within same sql instance
- Setting up Custom Fields
- Using the Lists
- Sync Queue
- Ongoing Synchronization
- Setting up Custom Fields
- Managing Users
- Error 5000 when running Customer or Leads Report in 6.1.92 or higher
- Drop Shipping
- Understanding Dependencies
- Shipping Multiple Sales Orders
- Sales orders with multiple shipping dates
- ShipRush crashes All Orders.
- Multiple-step OLE DB error when opening PO list- V 6.1.99
- Importing orders from QuickBooks
- Installing SQL Server 2012 for All Orders
- The All Orders User Interface
- Why does the Batch Shipping screen pop up when I am trying to fill a Sales Order?
- Designing and Using All Orders Report
- Accessing All Orders Web & Mobile outside the local network ( external IP)
- Invalid object name deleted
- Error- You have no items. Or one or more of your amounts is not associated with an item. Please enter an item.
- Setting up SMTP Email with Office 365
- Creating Custom Data Sources For Custom Reports
- Price Levels
- Working with styles
- Understanding Back Orders
- AO Web - Fix Date On Reports
- Typical Sales Cycle Work Flow
- How to make items inactive
- Multi-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done--- Version 6.2.35 only ( SO LIST )
- Checking customer credit
- Sales Orders With Multiple Ship To Addresses
- Processing Customer Returns
- Home Screen
- How To: Setting up templates for the subject and body of emails
- Adjusting Preferences
- Creating a Company File
- Creating a New Sales Quote
- Importing Data from Excel
- Using Drop-down lists
- A QuickBooks company data file is already open and is different then the one requested
- Error 526- One or more lines does not have an item
- Installing AOM for Windows 10 Systems
Related Articles
Thank you for your feedback!
Thank you! Your comment has been submitted for approval.
Copyright © 1999 – 2021 All Orders is a product of NumberCruncher.com, Inc.. All rights reserved.