It could be a permissions problem. Namely, that the service has not been given permission to write to the location you have specified.
Possibly, k: is a drive on the network and you have started the service under an account that doesn’t have permissions to access/write to the k: drive?!
If the ASA server dialog window is opened with the service (or if you’re working on Windows and the SQL icon shows up in the task bar - simply double-click on the icon). This window will tell you the specific reason the backup didn’t work.
david_jonker:
It could be a permissions problem. Namely, that the service has not been given permission to write to the location you have specified.
Possibly, k: is a drive on the network and you have started the service under an account that doesn’t have permissions to access/write to the k: drive?!
If the ASA server dialog window is opened with the service (or if you’re working on Windows and the SQL icon shows up in the task bar - simply double-click on the icon). This window will tell you the specific reason the backup didn’t work.
What platform are you working on?
David
OKay I am a step further now
I. 09/29 18:00:00. Handler for event 'backupPostcode' caused SQLSTATE '08W46'
I. 09/29 18:00:00. Error during backup: Could not create directory "K:\Devoon\backup Assyst"-- No such file or directory
I dont understand this. When I run the event with ASA started up as a program it has no problem. As a service it gives me this error. K: a partition on the hard-drive (not a network-drive) I made the service as an Administrator having all the priviliges one could have. And we are running on windows 2003 server
I wanted to download your Backup PDF Document, but I only get an error message that this url dowsn’t exist.
I would be very much interested in your info.
Best regards, Robert
Westy:
I have put together an Acrobat PDF file containing screen shots of how to create backup schedules with Sybase Central at:
The last page of the file includes a paragraph that explains how to save time by copying and pasting groups of Monday through Friday backup events from the events folder of one database to the events folder of other databases.
I am NOT an expert on Sybase backups. This file represents my first attempt at putting together a file that I can make available to my users on my web site. However, before doing so I want to make sure that the information it contains is both clear and accurate. I would greatly appreciate any suggestions and comments.
I would be particularly interested in knowing if anyone has figured out how to import or paste schedules and events across multiple databases all at one time. In other words, a way that I could set this up once, export the settings and then make them available to all my customers (my customers all have the same Servoy solution).
My objective is to establish automatic scheduled Monday through Friday backups (full archive backups) of all the Sybase database files and their corresponding log files while the files are being paused by Sybase at the same time each evening. The approach described in the PDF file that I have provided at the above link appears to achieve this, but if there is another way of doing it that would not require our users to open Sybase Central at all, that would be even better.
I checked with our technical support organization.
Here’s what they had to say:
If they have not set up the service with a specific account
then they are running under the local account “SYSTEM”
[aka localsystem] and that account has no credentials
[more specifically null credentials] exept whatever permissions
are granted explicitly to it or acquired implicitly as a member
of the local security group Everybody.
One typically starts by running the server in the foreground
[as the intended user] to check required permissions and
then either create the service to run as that account or
grant the required permissions to SYSTEM.