Files

116 lines
7.9 KiB
HTML

<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="generator" content="Adobe RoboHelp 2019">
<title>Schedule Third-party, Automated Data Backups</title>
<link rel="StyleSheet" href="../qbpos.css" type="text/css">
<style type="text/css">
/* FORCE ALL FONTS TO 12PT */
* { font-size: 12pt !important; }
body, p, li, ol, ul, div, span, td, th, h1, h2, h3, h4, h5, h6 { font-size: 12pt !important; }
</style>
<style title="hcp" type="text/css">
<!--
img.hcp1 { border:none; }
table.hcp2 { vertical-align:top; }
tr.hcp3 { vertical-align:top; }
td.hcp4 { padding-right:10px;
padding-left:10px; }
span.hcp5 { font-weight:bold; }
-->
</style>
</head>
<body>
<script type="text/javascript" src="../ehlpdhtm.js" language="JavaScript1.2"></script>
<p class="Help-Heading-1">Schedule Third-party, Automated Data Backups</p>
<p class="Help-Text">&#160;</p>
<p class="Help-Text">Some Point of Sale users prefer to backup their Point of Sale data as part of a larger network backup. Typically, these backups are automated, using a third-party application that creates and copies the backup file to another networked computer, to a tape drive, or to an online backup service.</p>
<p class="Help-Text">If you wish to include your Point of Sale data in a third-party backup, you will need to first shut down the Point of Sale Database Manager service. This Windows service runs on your Point of Sale <a href="../qbpos_help_and_support/help_wstypes.htm">Server Workstation</a> and controls access to the Point of Sale data. Third-party applications cannot access the data if the Database Manager is running.</p>
<p class="Help-Text">&#160;</p>
<p class="Help-Warning"><img src="../image/warning_icon_small.gif" alt="Warning" title="Warning" width="24" height="25" border="0" class="hcp1"> <span>&#160;</span><span style="font-weight: bold; ">Warning:</span> This procedure applies to the use of a third-party, automated backup application running outside of Point of Sale. It does not apply to, and may interfere with, <a href="backup_automatic.htm">scheduled backups within Point of Sale</a>. Ensure that Client workstations have exited Point of Sale before shutting down the Database Manager. Any unsaved work will be lost and all workstations will be automatically disconnected from the data with this procedure.<br>
<br>
This procedure is provided as a convenience and is recommended only for advanced users with an understanding of their Windows operating system, the use of batch files, and of the third-party application being used. Intuit does not provide support for third-party applications or for Windows features. Consult a qualified computer consultant if you need additional assistance with this procedure.</p>
<p class="Help-Text">&#160;</p>
<p class="Help-Info-Line">Click a link for more information:</p>
<p class="Help-Text"><a class="dropspot" href="javascript:TextPopup(this)" id="a1">How it works <img src="../image/expand_icon.GIF" alt="Click to expand/collapse topic" title="Click to expand/collapse topic" width="11" height="11" border="0" class="hcp1"></a></p>
<div class="droptext" id="POPUP343486987" style="display: none;">
<table cellspacing="0" bgcolor="#FFFFEC" class="hcp2">
<col style="width: 100%;">
<tr class="hcp3">
<td style="width:100%;" class="hcp4">
<p class="Help-Text">You'll create two batch files; one to stop the Point of Sale Database Manager service and the other to restart it. You then use the Windows <span class="hcp5">Scheduled Tasks</span> manager to schedule the batch files to run, with time in between them for your third-party application to complete its backup routine.</p>
<p class="Help-Text">If the backup is to occur when the computer is unattended, such as overnight, complete and save all Point of Sale activities and close Point of Sale, but leave the Server Workstation powered on.</p>
<p class="Help-Note"><span class="hcp5">Multi-Store Note</span>: If you are also scheduling Store Exchanges to occur overnight, you must leave Point of Sale running on the Server Workstation. Schedule the Store Exchange to complete before the first batch file is scheduled to shut down the Database Manager. The connection to the database from the server will be lost and Point of Sale will have to be restarted to restore it in the morning.</p>
</td>
</tr>
</table>
<p>&#160;</p>
</div>
<p class="Help-Text"><a class="dropspot" href="javascript:TextPopup(this)" id="a2">Create the batch files <img src="../image/expand_icon.GIF" alt="Click to expand/collapse topic" title="Click to expand/collapse topic" width="11" height="11" border="0" class="hcp1"></a></p>
<div class="droptext" id="POPUP343411041" style="display: none;">
<table cellspacing="0" bgcolor="#FFFFEC" class="hcp2">
<col style="width: 100%;">
<tr class="hcp3">
<td style="width:100%;" class="hcp4">
<p class="Help-Text">Use Notepad or another text editor to create the two batch files. Save the files anywhere on the Server Workstation.</p>
<p class="Help-Text">Save the first batch file with a name like <span class="hcp5">QBPOS_DBMgr_STOP.bat</span> and include the following two lines:</p>
<p class="Help-Indent">@echo off</p>
<p class="Help-Indent">net stop "QBPOS Database Manager v7"</p>
<p class="Help-Text">&#160;</p>
<p class="Help-Text">Save the second batch file with a name like <span class="hcp5">QBPOS_DBMgr_START.bat</span> and include the following two lines:</p>
<p class="Help-Indent">@echo off</p>
<p class="Help-Indent">net start "QBPOS Database Manager v7"</p>
<p class="Help-Indent">&#160;</p>
<p class="Help-Note"><span class="hcp5">Note</span>: If you prefer, do not create a batch file to restart the Database Manager and it will be automatically restarted when Point of Sale is next launched on the Server Workstation.</p>
</td>
</tr>
</table>
<p>&#160;</p>
</div>
<p class="Help-Text"><a class="dropspot" href="javascript:TextPopup(this)" id="a3">Schedule the tasks <img src="../image/expand_icon.GIF" alt="Click to expand/collapse topic" title="Click to expand/collapse topic" width="11" height="11" border="0" class="hcp1"></a></p>
<div class="droptext" id="POPUP343410632" style="display: none;">
<table cellspacing="0" bgcolor="#FFFFEC" class="hcp2">
<col style="width: 100%;">
<tr class="hcp3">
<td style="width:100%;" class="hcp4">
<ol style="list-style: decimal;">
<li class="p-Help-Steps">
<p class="Help-Steps">From the Windows Control Panel, select <span class="hcp5">Scheduled Tasks</span>.</p>
</li>
<li class="p-Help-Steps">
<p class="Help-Steps">Select <span class="hcp5">Add Scheduled Task</span>.</p>
</li>
<li class="p-Help-Steps">
<p class="Help-Steps">When the wizard asks you to select a program to run, browse to the STOP batch file you created and enter the frequency (daily, weekly, etc.) and time to stop the service.</p>
</li>
<li class="p-Help-Steps">
<p class="Help-Steps">Repeat for the START batch file. Allow enough time for your third-party application to complete its backup.</p>
</li>
</ol>
<p class="Help-Text"><span class="hcp5">Test the tasks</span>: Right-click on the task in the scheduler and select <span class="hcp5">Run</span>. If you bring up the Windows Services window you will be able to observe that the task has stopped/started when you refresh the window.</p>
<p class="Help-Text">Refer to your third-party application's documentation for information about scheduling it to run at the desired time.</p>
<p class="Help-Text">&#160;</p>
<p class="Help-Note"><span class="hcp5">Note</span>: If you are on a network domain, you may need to enter a Windows username and password when scheduling the tasks. Enter a user with Administrator privileges or the task may not run.</p>
</td>
</tr>
</table>
<p>&#160;</p>
</div>
<script type="text/javascript" language="JavaScript1.2">//<![CDATA[
if( typeof( TextPopupInit ) != 'function' ) TextPopupInit = new Function();
TextPopupInit('a1','POPUP343486987');
TextPopupInit('a2','POPUP343411041');
TextPopupInit('a3','POPUP343410632');
//]]></script>
</body>
</html>