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

    Unanswered: Threshold procedure

    Hi,

    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: 4.41.1.1: Creating new disk file C:\WINNT\system32\ddiftl45.
    May 24 14:21:55 2006: Backup Server: 4.141.2.40: [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 ?

    Rgds
    Wilson

  2. #2
    Join Date
    Apr 2004
    Posts
    79

    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
  •