Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Posts
    5

    Unanswered: BackupIoRequest::WaitForIoCompletion - Unable to find ryme or reason!

    Event Type: Error
    Event Source: MSSQLServer
    Event Category: (6)
    Event ID: 17055
    Date: 8/11/2002
    Time: 8:00:08 PM
    User: xxxxxxxxxx
    Computer: xxxxxxxxxx
    Description:
    18210 :
    BackupIoRequest::WaitForIoCompletion: read failure on backup
    device 'd:\mssql7\data\Debtors_Data.MDF'. Operating system error 1453
    (Insufficient quota to complete the requested service.).

    This is the event log view from a SQL7 No service pack server on a W2k server SP2.

    The D: drive where the backup file is going has over 13GB free !

    Has any one else had this error ? M$ have no information

    Cheers

    Dave
    Last edited by midwinter; 11-11-02 at 02:40.

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Exclamation

    [size =1]RE:
    read failure on backup device 'd:\mssql7\data\Debtors_Data.MDF'. Operating system error 1453 (Insufficient quota to complete the requested service.).
    This is the event log view from a SQL7 No service pack server on a W2k server SP2.
    The D: drive where the backup file is going has over 13GB free !
    Has any one else had this error ? M$ have no information
    [/size]

    Q1 Has any one else had this error ?
    A1 This looks like it may be a disk quota related error.

    Q2 The D: drive where the backup file is going has over 13GB free!
    A2 Fine, but if disk quotas are enabled, how much is available on the D:\ drive for the service account under which sql server is running?

    S1 Are you able to complete any (small) backup dumps? (If not, some DB may have already grown to meet an existing quota limit.)

    S2 Try deleteing all existing backup files and then attempt a (very small) backup dump, say for master.

  3. #3
    Join Date
    Sep 2002
    Posts
    5

    Quota

    Hi,

    No Quota's are enabled

    The 'Job' ran successfully the following morning after the initial error.

    This morning (Tuesday) the Job ran successfully.

    I am thinking that the Quota reference is 'system resources' rather than disk quota.

    I think that even though the source is MSSQLSERVICE i believe its a W2K issue.

    OS W2K SP2
    1x 1Ghz CPU
    Memory 2GB
    Hardware RAID
    2x Database.
    Cataloging 3,2xx,xxx records (manual incremental population)

    I have read where people have Service Packed there OS to SP3 but this still doesnt fix [there] problem

    Dave

  4. #4
    Join Date
    Oct 2002
    Posts
    369

    Question

    RE:
    Hi, No Quota's are enabled
    The 'Job' ran successfully the following morning after the initial error.
    This morning (Tuesday) the Job ran successfully.
    I am thinking that the Quota reference is 'system resources' rather than disk quota. I think that even though the source is MSSQLSERVICE i believe its a W2K issue.

    OS W2K SP2
    1x 1Ghz CPU
    Memory 2GB
    Hardware RAID
    2x Database.
    Cataloging 3,2xx,xxx records (manual incremental population)

    I have read where people have Service Packed there OS to SP3 but this still doesnt fix [there] problem Dave
    Q1 [No Quota's are enabled]
    A1 That's too bad it would have been an easy fix.

    Q2 [I am thinking that the Quota reference is 'system resources' rather than disk quota. I think that even though the source is MSSQLSERVICE i believe its a W2K issue.]
    A2 Well yes, kind of (probably); the API likely ends up calling the same lower level drivers in any case.

    S1 The issue may also be related to driver corruption, driver coding issues / bugs and / or authentication and / or ACL issues. If you happen to have also very recently updated any disk / array drivers, you might consider either attempting to refresh the driver update(s) and / or undoing them?
    As far as I understood there (were / are in 99 / 00?) some issues having to do with "IO set completion" that had / have something to do with switches between different levels of kernel drivers that array controller drivers initiate (maybe related, maybe not?).
    As to authentication, I've seen (and experienced) problems with some network domains wherein every now and then the (domain controller?) decides the Sql Server / service account doesn't have the neccessary rights to dump wherever (usually, but not always, also accompanied by logon failures in the event log), which causes similar issues.

  5. #5
    Join Date
    Oct 2002
    Posts
    369

    Re: BackupIoRequest::WaitForIoCompletion - Unable to find ryme or reason!


    Event Type: Error
    Event Source: MSSQLServer
    Event Category: (6)
    Event ID: 17055
    Date: 8/11/2002
    Time: 8:00:08 PM
    User: xxxxxxxxxx
    Computer: xxxxxxxxxx
    Description:
    18210 :
    BackupIoRequest::WaitForIoCompletion: read failure on backup
    device 'd:\mssql7\data\Debtors_Data.MDF'. Operating system error 1453
    (Insufficient quota to complete the requested service.).

    This is the event log view from a SQL7 No service pack server on a W2k server SP2.

    The D: drive where the backup file is going has over 13GB free !

    Has any one else had this error ? M$ have no information

    Cheers

    Dave
    Q1 This is the event log view from a SQL7 No service pack server???
    A1 I missed that detail previously. If I read that correctly why is that? You may want to check out MS Q274310 (or "Why you may consider applying Service Pack 3 for Microsoft SQL Server 7.0")?

    http://support.microsoft.com/default...b;EN-US;274310

Posting Permissions

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