Post reply

Error: 823, Severity: 24, State: 2 Disk I/O error

  • September 19, 2005 at 3:20 pm

    #591165

    For starters, you are executing the RTM version (original CD installation, with no service packs). Upgrading to SP4 may or may not be advisable. You defintely want to search this sight. There are a number of threads concerning 'issues' or potential 'issues' with SP4. You will have to determine if any are relevant in your case. At a minimum I'd suggest SP3a and possibly 'hot fix' 818 (it's a security thing). Also while you have the server for maintenance I'd also run Windows Update for the OS to get all of the latest and greatest 'fixes' for W2K SP4 as well. (you're probably looking at at least 2 reboots). The first for the new windows installer, then as many as are called for after that.

     

    Now back to one of your original questions. Freeing up space on the C: drive and moving the pagefile. Yes you should definitely free up space on the C: drive. Moving the pagefile has a couple of ramifications. First and foremost, another reboot. Second, if you ever need a memopry dump for MS PSS you will not get one unless you have a pagefile on the C: drive.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • September 20, 2005 at 4:55 pm

    #591544

    Thanks for the reply rudy,

    I should've made it clear that I will not be responsible for the implentation and investigation of possible issues that may or may not arise from the application of any service packs or pagefile location.

    My main concern and questions was if anyone has come across the scenario explained in my original post where if the db was taken out of the enviroment, the consistency errors are no longer reported.

    Suggestions on how I would resolve this issue within this environment once space is freed up and service packs are applied are very welcome, as I don't see the need to run a dbcc checkdb with repair_allow_data_loss in this case.

    Thanks

    Andrew.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply