Pause pervasive sql v8.6

JasonDuncanworks
JasonDuncanworks used Ask the Experts™
on
I have a Terminal Server that runs A database Service Manager for Workgroup engine 8.60.192.030.
Pervasive SQL V8.6

How can I pause or stop this for my backup to run at night?
NovaBackup latest version

Thanks
Jason
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
MirtheilSoftware Developer
Commented:
If you have Pervasive Data files open, you'll  want to look at Continuous Operations Mode (http://docs.pervasive.com/products/database/psqlv11/wwhelp/wwhimpl/js/html/wwhelp.htm#href=advops/backup.08.5.html).  With the Workgroup Engine, you can't use Backup Agent, but can use the Continuous Operations through BUTIL (BUTIL -STARTBU and BUTIL -ENDBU).  That won't pause the actual engine but will allow you to backup open data files.  
If you want to actually stop the engine, you'd want to make sure everyone is out then run the PVKILLWG.EXE program.  You can restart the engine by executing "W3DBSMGR.EXE -srde".  There are several programs for kicking users out of PSQL including one on the Pervasive Component Zone (http://cs.pervasive.com/files/19/default.aspx) and one from Goldstar Software (don't know the URL).

Author

Commented:
@mirtheil -  From your link -
"However, in the event of a hard drive failure, if you use Continuous Operations to make backups, you will lose all changes to your data since the last backup"

If I use the command for backups I could lose data? Could you explain that for me?
President and Btrieve Guru
Commented:
The free KillUser tool can be found at www.goldstarsoftware.com/tools.asp.  This will completely kick out all users and make a simple file system backup work perfectly every time.  It is a bit easier than killing the entire engine, but a rogue user COULD re-open the files between the KillUser and the time the backup actually runs.

If you want to allow users to stay in the system, then ContOps is the next best solution.  You need to write the scripts, but some examples can be found at www.goldstarsoftware.com/press.asp in the white paper on getting proper backups.
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

MirtheilSoftware Developer

Commented:
If I use the command for backups I could lose data? Could you explain that for me?
The way Continuous operations works is that is closes the data file, and opens a special delta file (filename.^^^).  Clients that are making changes to the file while in Continuous Operations would be written to the delta file.  This is all handled by the PSQL engine and nothing special has to be done by the application.  If there was a hard drive failure or power went out, that delta file potentially could not be recovered and those changes would be lost.

Author

Commented:
No users are in the system at night but just in case I run batch file to kick them all,

Then - batch file - PVKILLWG.EXE

Backup run

After - W3DBSMGR.EXE -srde

Will see how it goes in the AM.

Author

Commented:
Got a message in the morning stating
 - Remote and or local applicatoins are active and connected to the Pervasive database. Use the Pervasive Monitor utility to view the active Microkernel users.
If you choose to continue shutting down, applications will fail with unredictable results and the system may not be properly cleaned up. Continue shut down-

Is there a way for a clean stop?
MirtheilSoftware Developer

Commented:
One thing I didn't think of was how the WGE was running.  Is it running as an application or service?  
When it's actin as a server, I would think that running it as a service might be a better option.  

But, back to the issue at hand.  I did some testing, and as long as there were no users active, the PVKILLWG.EXE shut the engine down cleanly.  If I had any users active, it displayed the message you saw.  You'll probably need to use the KillUser tool or something similar before shutting the engine down.  Either that or use Continuous Ops.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial