Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Threshold procedure


    I am using ASE 12.5 on windows 2000. My database services are running using a domain account and this account has RW permissions to dump,data,log and sybase home.

    I have written a threshold procedure which will dump tran when 70% of logsegment is full.

    While doing my testing of this proc, this proc is getting fired but it is unable to take a tran dump on Dump folder as specified in the proc..

    select @devname = "e:\db_dump\" + @dbname + "db_" +
    stuff(stuff(convert(char(8),getdate(),108),3,1,'_' ),6,1,'_') + '_' +
    -- convert(char(8),getdate(),108) +
    substring(convert(char(8), getdate(), 112),5,4) + ".txn"

    dump transaction @dbname to @devname

    and I get a message in backup.log which states
    May 24 14:21:55 2006: Backup Server: Creating new disk file C:\WINNT\system32\ddiftl45.
    May 24 14:21:55 2006: Backup Server: [7] The 'CreateFile' call failed for device 'C:\WINNT\system32\ddiftl45' with error number 5 (Access is denied). Refer to your operating system documentation for further details.

    When I try to execute this proc manually, I am getting a transaction dump.

    So can somebody explain why it is writing on c:\winnt\system32, when it is fired automatically ?


  2. #2
    Join Date
    Apr 2004

    Working now..

    I got it working as I omitted one of the parameters.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts