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
Pervasive SQL V8.6
How can I pause or stop this for my backup to run at night?
NovaBackup latest version
Thanks
Jason
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
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.
Then - batch file - PVKILLWG.EXE
Backup run
After - W3DBSMGR.EXE -srde
Will see how it goes in the AM.
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?
- 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?
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.
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.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
"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?