Question Re: SAP Sybase ASE Database Backup in Technology Q&A

SAP Sybase ASE Database Backup

Former Member — Wed, 19 Feb 2014 06:53:08 GMT

Hi all,

Actually i want to about SAP Sybase ASE backup .

Should we stop all activity of SAP application server,

like no user log in time of backup before taking the

backup of Sybase with dump command.

Please help me asap

Thanks

Ashish Kumar

Re: SAP Sybase ASE Database Backup

kimon_moschandreou — Wed, 19 Feb 2014 08:10:51 GMT

Hello,

It is not necessary to stop user activity and you may check this SyBooks Online for more information

Regards,

Kimon

Re: SAP Sybase ASE Database Backup

Former Member — Wed, 19 Feb 2014 09:27:15 GMT

Thanks Sir,

sir i did not find any information the link you are shared to me

please can you give me more clarity .

Re: SAP Sybase ASE Database Backup

kimon_moschandreou — Wed, 19 Feb 2014 09:32:54 GMT

the link sends you in ASE documentation where the backup is described. concerning the question if you need to stop the App server in order to take a backup the answer is no, the database can be online while dump command is running

Re: SAP Sybase ASE Database Backup

Former Member — Wed, 19 Feb 2014 09:39:41 GMT

Sir

my intention is not ask for proof, actually you gave me link that's why i asked you where it is mention

Thanks for reply

Re: SAP Sybase ASE Database Backup

former_member188958 — Wed, 19 Feb 2014 13:58:14 GMT

I think a better reference to the documentation would be the Commands Reference page on the dump database command.

This page has a bullet point giving the general rule that it is not necessary to stop activity while taking a backup:

Scheduling dumps

Adaptive Server databasedumps are dynamic—they can take place while the database is active. However, they may slow the system down slightly, so you may want to run dump database when the database is not being heavily updated.

[If your recovery strategy is to take only daily full database dumps but not transaction log dumps, another reason to schedule the dumps for slow times is that when loaded, there will be less recovery to do so the database will be able to come online faster.]

This page also discusses the exception, which is when the dump is to be used for a cross-platform dump and load:

Before you run dump database, for a cross platform dumpand load, move the database to a transactional quiescent status:

Verify the database runs cleanly by executing dbcc checkdb and dbcc checkalloc.
To prevent concurrent updates from open transactions by other processes during dump database, use sp_dboption to place the database in a single-user mode.
Flush statistics to systabstats using sp_flushstats.
Wait for 10 to 30 seconds, depending on the database size and activity.
Run checkpoint against the database to flush updated pages.
Run dump database.

Re: SAP Sybase ASE Database Backup

Former Member — Thu, 20 Feb 2014 04:08:43 GMT

Thanks Bret !!!!

It's very helpful to me

Re: SAP Sybase ASE Database Backup

Former Member — Thu, 20 Feb 2014 04:17:27 GMT

Bret !! i have one more question,

Can we take Sybase database dump backup on shared drive.

scenario like this :

Suppose i shared a drive on computer name as \\palsapdev\t and i accessed it on another computer name as palsapqas, now i want to take backup at share drive \\palsapdev\t

Re: SAP Sybase ASE Database Backup

former_member188958 — Thu, 20 Feb 2014 04:26:19 GMT

I believe that would work.

-bret

Re: SAP Sybase ASE Database Backup

Former Member — Thu, 20 Feb 2014 04:32:40 GMT

but

i think it is not working ?

Re: SAP Sybase ASE Database Backup

kimon_moschandreou — Thu, 20 Feb 2014 07:06:27 GMT

it works, but it will be slower. Also you need to check permissions, so the user running the Sybase Backup server should have access on this remote drive.

Kimon

Re: SAP Sybase ASE Database Backup

Former Member — Thu, 20 Feb 2014 07:55:29 GMT

Thanks Kimon,

Can you give me more clarity about this process step by step.

While i already gave all permission to shared partition,

but i do not the process of what permission have to

provide to Sybase backup server

i use following command :

dump database model to "\\palsapdev\t\model.dmp"

but give error

Re: SAP Sybase ASE Database Backup

kimon_moschandreou — Thu, 20 Feb 2014 07:59:13 GMT

Hi,

Check on the machine of ASE which user runs the Sybase Backup Server service. The defaule is "Local System" which a local user and has not permissions to run anything in the network. Change the user to a domain user which has access to the path you want to take the back and it will work

Regards,

Kimon

Re: SAP Sybase ASE Database Backup

Former Member — Thu, 20 Feb 2014 08:08:57 GMT

HI Ashish,

What is the error message ? From what you have posted it look like you are running Windows platform and then ASE will use the Windows Operting system call createfile , writefile .

If you are on Windows and start ASE as a service it is possibly that it is started with the system account.

Dumping across a network

Niclas