Automated Nightlt DB Backup

Questions and Answers about the POS Pizza 6 & 7 Databases
New Member
Posts: 1
Joined: Fri May 28, 2010 9:29 pm

Automated Nightlt DB Backup

Postby adrians 1 » Sat Nov 10, 2012 9:52 am

Is there a way to automate backup from the command line or scheduler?

Site Admin
User avatar
Posts: 2082
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Automated Nightlt DB Backup

Postby Scott » Sun Nov 11, 2012 9:03 am

Just backup the *.PZ6 files from your server folder. Any backup program that includes a scheduler should be able to do this.

Scott

New Member
Posts: 1
Joined: Fri Dec 14, 2012 12:16 pm

Re: Automated Nightlt DB Backup

Postby kupiszew » Fri Dec 14, 2012 12:19 pm

So, just to be clear, all we need are the *.PZ6 files. I saw mention of an XML file for the meun, is this a separate backup if you want it, or is that informaiton stored in the database as well? Basically, I want to make sure I've got every file the system could need to be up and running as is. I am new to the platform, but the system is not new.

Thanks in advance for any advice.

Joe...

Site Admin
User avatar
Posts: 2082
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Automated Nightlt DB Backup

Postby Scott » Fri Dec 14, 2012 11:05 pm

kupiszew wrote:So, just to be clear, all we need are the *.PZ6 files. I saw mention of an XML file for the meun, is this a separate backup if you want it, or is that informaiton stored in the database as well? Basically, I want to make sure I've got every file the system could need to be up and running as is. I am new to the platform, but the system is not new.


The entire database is in the .PZ6 file (typically POSPizza.PZ6).

Menu data can be exported to XML so that you can import it at other stores. The XML menu data is just an easy way to move menu-only data between sites.

Scott

New Member
Posts: 1
Joined: Sun Mar 10, 2013 4:13 pm

Re: Automated Nightlt DB Backup

Postby mregpala » Fri May 10, 2013 11:21 am

Does the database need to be shutdown to copy the file?

Member
User avatar
Posts: 14
Joined: Thu Dec 13, 2012 11:00 am

Re: Automated Nightlt DB Backup

Postby JohnnyD » Fri May 10, 2013 12:10 pm

mregpala wrote:Does the database need to be shutdown to copy the file?


Shutdown is not a "requirement", but it is a good idea to make sure that you get an exact duplicate of the db file and that no transactions are occurring during the copying process.

Hope this helps.

- John

Site Admin
User avatar
Posts: 2082
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Automated Nightlt DB Backup

Postby Scott » Fri May 10, 2013 1:11 pm

If you are running this at night, while the POS system is idle, then you should be fine.

Scott

Return to Database Help and Discussion

Who is online

Users browsing this forum: No registered users and 1 guest