RE: Backing Up The POS Database

Questions and Answers about the POS Pizza 6 & 7 Databases
Member
Posts: 6
Joined: Thu Sep 26, 2013 11:54 am

RE: Backing Up The POS Database

Postby CataldosRD » Wed Apr 15, 2015 2:44 pm

Couple of questions:

1) Can i back up the database in the middle of the night without stopping the DB server Admin Tool or would i need to write a script to stop the service before I copied the database and then restart it??

2) Can you please list only the necessary files that i need to back up for the POS Pizza 6 software.

Thank You!!

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

Re: RE: Backing Up The POS Database

Postby Scott » Thu Apr 16, 2015 6:06 am

Generally if the system has been idle for awhile, then you should be safe to back it up without stopping the service. The only file that needs to be backed up is the pospizza.PZ6 file located in the C:\POSPizza6\Server folder. If you have created additional databases, or manually specified a different name than default, then those databases may also need to be backed up. Basically all files in the folder with the .PZ6 extension.

Scott

Veteran Member
User avatar
Posts: 244
Joined: Wed Oct 12, 2011 1:38 pm
Location: Pennsylvania

Re: RE: Backing Up The POS Database

Postby synpse » Fri Jan 22, 2016 8:05 pm

Also, grab your local settings .INI file in the c:\pospizza\cs\ folder, too. it really helps to have that config file.


I just ZIP the entire c:\pospizza folder and add the date to the filename. such as POSPizza-2016-01-22.zip That goes in my Google Drive folder, so it saves in the cloud. (offsite backup) And send it to my d:\BACKUP folder, which is a USB drive. (local backup) Just "in case" anything happens to the main/server computer hard drive. A little bit of prevention saves disasters. I also do the same with the X-Charge backup file. Re-installing that can be a hassle without it.

Return to Database Help and Discussion

Who is online

Users browsing this forum: No registered users and 1 guest