Advantage Database Server Shutdown

[former_member1062412]

Hello All - -

I'm new to ADS. Most of my experience is with MS SQL Server.

We have started using a third party application that uses ADS as its backend. The software vendor recommends simply copying the database directory as a backup method, saying that we should use backup software that will copy files, even when they are still open.

As an experienced IT/database professional, this makes me uncomfortable.

My alternate proposal was to simply stop the ADS service (on Windows server). That way, there will be no locked files.

The software vendor countered: "Shutting down the Advantage database is complicated as you need to be sure all users are logged off."

Is this true?

As a database administrator, I often have to shut MS SQL Server down. It will gracefully close connections, terminate transactions, an so on. Is it true that stopping the ADS service is a risky business, requiring that the DBA manually log each user off?

- - Herb

[former_member751964]

Thank you for visiting SAP Community to get answers to your questions. Since you are new, I recommend that you familiarize yourself with our Q&A Tutorial: https://developers.sap.com/tutorials/community-qa.html. It provides tips for preparing questions that draw responses from our members. Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM

Thank you!

[former_member1252007]

Hello Herb; If all you want is to backup your db, then there is no need to shutdown. Just use the backup utility. It works great even as transactions are currently happening. The way it works, is that the backup utility takes a snapshot of the db at the moment the backup begins. All transactions that began after that point are left out of the backup. Look for backup utility on the documentation.

Hope that helps,

[james_beard2]

I would recommend using the ADSBACKUP utility that ships with Advantage Database Server for backup and restore of ADS files.

This can backup ADS files that are in use without the need to shutdown the ADS Service.