Avatar of JasonDuncanworks
JasonDuncanworks
Flag for United States of America asked on

Pause pervasive sql v8.6

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
Microsoft SQL ServerWindows Server 2003

Avatar of undefined
Last Comment
Mirtheil

8/22/2022 - Mon
SOLUTION
Mirtheil

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
JasonDuncanworks

ASKER
@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?
ASKER CERTIFIED SOLUTION
Bill Bach

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Mirtheil

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.
JasonDuncanworks

ASKER
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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
JasonDuncanworks

ASKER
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?
Mirtheil

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.