User Tools

Site Tools


jobmatix_jobtracking:maintaining_jobmatix

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

jobmatix_jobtracking:maintaining_jobmatix [2016/12/06 11:03]
azmin created
jobmatix_jobtracking:maintaining_jobmatix [2016/12/06 11:08] (current)
azmin [JobMatix Database- Backup and Restore]
Line 22: Line 22:
 <​p><​em><​strong>​Important:</​strong></​em><​br /> <​p><​em><​strong>​Important:</​strong></​em><​br />
 It is essential that SQL Server users (in fact everyone) have an  appropriate disaster recovery plan for critical systems to ensure that  important data can be recovered in the event of the loss of a server.. ​ SQL  Server databases are <​strong><​em>​not</​em></​strong>​ normally recovered by simply ​ reloading Windows data file backups.. ​   When a server is  re-built, SQL Server must be re-installed,​and all databases RESTORED from their  backup files using the SQL Server RESTORE function. ​   The  Microsoft MSDN website is a good source of Backup/​Restore information:</​p>​ It is essential that SQL Server users (in fact everyone) have an  appropriate disaster recovery plan for critical systems to ensure that  important data can be recovered in the event of the loss of a server.. ​ SQL  Server databases are <​strong><​em>​not</​em></​strong>​ normally recovered by simply ​ reloading Windows data file backups.. ​   When a server is  re-built, SQL Server must be re-installed,​and all databases RESTORED from their  backup files using the SQL Server RESTORE function. ​   The  Microsoft MSDN website is a good source of Backup/​Restore information:</​p>​
-<p><​span style="​font-size:​ small;"​><​em>​Introduction to Backup and Restore Strategies in SQL  Server:</​em>​</​span><​br /> +<​p><​em>​Introduction to Backup and Restore Strategies in SQL  Server:</​em><​a href="​http://​msdn.microsoft.com/​en-US/​library/​ms191239(v=SQL.90).aspx">​http://​msdn.microsoft.com/​en-US/​library/​ms191239(v=SQL.90).aspx</​a></​p>​ 
-<a href="​http://​msdn.microsoft.com/​en-US/​library/​ms191239(v=SQL.90).aspx">​<br /> +<​p>​Access to Backup and Restore SQL functionality is built into JobMatix, and is simple to access and execute.</​p>​
-http://​msdn.microsoft.com/​en-US/​library/​ms191239(v=SQL.90).aspx</​a></​p>​ +
-<​p>​Access to Backup and Restore SQL functionality is built into <em>JobMatix</em> and is simple to access and execute.</​p>​+
 <​p><​span style="​text-decoration:​ underline;"><​em>​Backup</​em></​span>​ calls<br /> <​p><​span style="​text-decoration:​ underline;"><​em>​Backup</​em></​span>​ calls<br />
-the SQL-Server &#​8220;​BACKUP DATABASE <​em>​databasename</​em>​ TO DISK &#8230; &#8221; command ​ to produce a <​em>​full</​em>​ backup ​ of the JobTracking database onto a backup file <​em>​(&#​8212;​JobTracking&#​8211;​.bak</​em>​) representing ​ the complete database at that moment in time.  The backup command is  available in JobMatix whether it is running on the server or on a  client system.</​p>​ +the SQL-Server &#​8220;​BACKUP DATABASE <​em>​databasename</​em>​ TO DISK &#8230; &#8221; command to produce a <​em>​full</​em>​ backup ​ of the JobTracking database onto a backup file <​em>​(&#​8212;​JobTracking&#​8211;​.bak</​em>​) representing the complete database at that moment in time. The backup command is available in JobMatix whether it is running on the server or on a client system.</​p>​ 
-<​p><​span style="​text-decoration:​ underline;"><​em>​Restore</​em></​span>​ calls the SQL Server &#​8220;​RESTORE ​ DATABASE <​em>​databasename</​em>​ FROM DISK &#8230; &#8221; command which will restore or  re-create the database on the server. ​ Restore can only be executed from  JobMatix running on the server machine..</​p>​ +<​p><​span style="​text-decoration:​ underline;"><​em>​Restore</​em></​span>​ calls the SQL Server &#​8220;​RESTORE ​ DATABASE <​em>​databasename</​em>​ FROM DISK &#8230; &#8221; command which will restore or re-create the database on the server. ​ Restore can only be executed from JobMatix running on the server machine..</​p>​ 
-<​p>&​nbsp;​</p+</html
-<​p><​strong>​Notes on JobMatix Settings:</​strong></​p+ 
-<​p>​1. ​  ​A sample text is provided for the  <​em>​Terms and Conditions</​em>​ printed at the bottom of the New  Service Agreement form. It will be installed automatically in the Jobmatix SystemInfo table (item is  <​em>​TermsAndConditions</​em>​) when the program is first run.  This text can be  edited by the user as required, by going the  Setting screen. ​ However, the overall size of the text should not be increased, due to  the space restrictions on the printout.</​p>​ +===== Notes on JobMatix Settings ​===== 
-<p>2. As part of the job completion ​ process, ​<em>JobMatix</​em>  ​will print out the service record form  ready for Job delivery. ​ Additionally,​ if an appropriate barcode font is  installed, the program will print out all the barcodes for the  product codes and serial numbers for all stock items chargeable ​ to the Job.   ​This is to enable them to be easily scanned into the RetailManager ​ sale transaction when the job is being invoiced out.  The Barcode font must  be provided by and installed by the business user on  each user machine if needed..  ​The name of the font has to be entered ​ into the JobTracking database through the JobMatix Settings screen..</p>+ 
 +<html
 +<p>1. A sample text is provided for the <​em>​Terms and Conditions</​em>​ printed at the bottom of the New Service Agreement form. It will be installed automatically in the Jobmatix SystemInfo table (item is  <​em>​TermsAndConditions</​em>​) when the program is first run.  This text can be  edited by the user as required, by going the Setting screen. However, the overall size of the text should not be increased, due to the space restrictions on the printout.</​p>​ 
 +<p>2. As part of the job completion ​ process, JobMatix will print out the service record form ready for Job delivery. Additionally,​ if an appropriate barcode font is  installed, the program will print out all the barcodes for the  product codes and serial numbers for all stock items chargeable ​ to the Job. This is to enable them to be easily scanned into the RetailManager sale transaction when the job is being invoiced out. The Barcode font must  be provided by and installed by the business user on each user machine if needed. The name of the font has to be entered into the JobTracking database through the JobMatix Settings screen.</​p>​
 <​p><​a href="​https://​i2.wp.com/​jobmatix.com.au/​wp-content/​uploads/​2012/​11/​JobMatix-Barcode-Setup.png"><​img class="​alignleft size-medium wp-image-229"​ alt="​JobMatix-Barcode-Setup"​ src="​https://​i1.wp.com/​jobmatix.com.au/​wp-content/​uploads/​2012/​11/​JobMatix-Barcode-Setup-294x300.png?​resize=294%2C300"​ data-recalc-dims="​1"​ /></​a></​p>​ <​p><​a href="​https://​i2.wp.com/​jobmatix.com.au/​wp-content/​uploads/​2012/​11/​JobMatix-Barcode-Setup.png"><​img class="​alignleft size-medium wp-image-229"​ alt="​JobMatix-Barcode-Setup"​ src="​https://​i1.wp.com/​jobmatix.com.au/​wp-content/​uploads/​2012/​11/​JobMatix-Barcode-Setup-294x300.png?​resize=294%2C300"​ data-recalc-dims="​1"​ /></​a></​p>​
 <​p>&​nbsp;</​p>​ <​p>&​nbsp;</​p>​
-<​p>​The ​ default FontSize is 9pt.  This can be changed by changing the value  of the size setting ​ (in <​em>​points</​em>​).</​p>​ +<​p>​The ​ default FontSize is 9pt.  This can be changed by changing the value  of the size setting (in <​em>​points</​em>​).</​p>​ 
-<​p>&​nbsp;</​p>​ +<p style="​font-size:​ 0.7em;">&#​8212;​ Page updated: 20-June-2012 10:40am. JobMatix Team</p
-<​p>&​nbsp;</​p>​ +</html>
-<​p>&​nbsp;</​p>​ +
-<​p>&​nbsp;</​p>​ +
-<​p>&​nbsp;</​p>​ +
-<​p>&​nbsp;</​p>​ +
-<​p>&​nbsp;</​p>​ +
-<​p>&​nbsp;​</​p>​ +
-<p style="​font-size:​ 0.7em;">&#​8212;​ Page updated: 20-June-2012 10:​40am. ​ JobMatix Team</​p>​+
jobmatix_jobtracking/maintaining_jobmatix.txt · Last modified: 2016/12/06 11:08 by azmin