Post reply

shrinkDB cause SQL Problems

  • August 8, 2002 at 10:37 am

    #64339

    I ran a shrink Database, on a test server, via

    EM

    taskpad

    shrink Database

    All hell broke out. Fatal errors, sql dump, lost connection with server and this goody in log file:

    "Process ID 12 tried to remove a buffer resource lock BUF pointer = 0x11785b00, page ptr = 0x1fbd8000, pageid = (0x1:0xe1fe), dbid = 7, status = 0xb, file = c:\MSSQL7\DATA\Mydata_DB.mdf that it does not hold in SDES SDES pointer = 0x214bf9d4. Contact Technical Support.."

    Everything recovered.

    I got curious, , it is a test server.. I ran DBCC shrinkdatabase in QA. I was expecting errors, it ran perfectly. SO.. I guess when you run shrinkdatabase from Em it DOESNT run dbcc shrinkdatabase? Or is something else going on!! I also have "removed unused space" option set when running optimization. That too ran OK.

    HMMM!

    karen

  • August 8, 2002 at 12:47 pm

    #434292

    I ran checkdb and there are no allocations or consistency errors. For all intents and purposes the DB comes back fine after the server shuts down and recovers the DB. Strange don't you think?

  • August 8, 2002 at 1:58 pm

    #434295

    Yes when I saw that contact tech support it threw me

    Thanks Solart

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

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