Post reply

DBCC CHECKDB resulted in error

  • June 1, 2009 at 4:27 pm

    #1003089

    all this happening in QA environment, which is in sql server 2005. We have the same database in production also, which is still in sql server 2000. So I want to give a try by restoring the database from current production database(from sql 2000) into QA (sql 2005)before calling MS.

    does this makes any sense???

  • June 1, 2009 at 4:35 pm

    #1003093

    You can try that, but I think you'll end up hitting the same issue. Don't forget that after the upgrade you need to run DBCC UPDATEUSAGE once before starting your test to clear out problems from 2000.

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Viewing 2 posts - 16 through 16 (of 16 total)

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