Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102

    Unanswered: Alter Database while "Suspect"

    Hi

    I got the following error
    Error: 823, Severity: 24, State: 4
    I/O error 33(The process cannot access the file because another process has locked a portion of the file.) detected during write at offset
    0x0000000a796000 in file xxxxxxxxx.ndf'.

    and the respective database could not be brought online - this was just due to a problem with a .ndf file containing only indexes...is there any way to connect to/alter a database while it is in this transitional state? (it would be no loss if i could just remove the file & its filegroup)

    (i tried starting with -f -c, but no go)

    thanks in advance
    des

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Check in your virus scan software to see if it ignores *.mdf, *.ndf and *.ldf. I am assuming this is on startup of the database? Say after recycling the SQL Server service, or rebooting the machine?

    Also, you will want to do some diagnostics on the disk (check with hardware vendor), in order to make sure the disk has not suddenly gone bad.

    Good luck, and let us know what happens.

  3. #3
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    What had happened was the folder/drive I put the index file on was set to compress contents (accidentally)...I figure the windows compression had a hold on it...happened after rebooting the machine (I thought it took real long to build those indexes - now i know why!)

    Disk seems fine though...

    Thanks for advice
    cheers
    des

    (what happened ultimately was db loss & a 12 hour snapshot delivery....eughh. wish i couldve just removed the index file somehow...)

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I thought I read it somewhere not to use compression on any files SQL touches, maybe with the exception of the error logs. You can lock out any interactive access to the data and log folders to prevent future mishaps.

Posting Permissions

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