Error moving SQL Server 2000 to SQL Server 2005 NOLOCK Error

  • Hi,

    I need to move a database from the SQL Server 2000 (32 bit) to SQL Server 2005.But,When I attacted my database to SQL Server 2005,it's gives me error.(NOLOCK error)

    Also , After I running dbcc check db command for database errors,I am receiving the following error.

    Server: Msg 8929, Level 16, State 1, Line 1

    Object ID 2: Errors found in text ID 727515136

    owned by data record identified by RID = (1:391:14) id = 491864819 and indid = 9.

    Server: Msg 8929, Level 16, State 1, Line 1

    Object ID 2: Errors found in text ID 727646208

    owned by data record identified by RID = (1:391:16) id = 491864819 and indid = 11.

    Server: Msg 8929, Level 16, State 1, Line 1

    Object ID 2: Errors found in text ID 768802816

    owned by data record identified by RID = (1:2243:15) id = 1796253504 and indid = 54.

    Server: Msg 8929, Level 16, State 1, Line 1

    CHECKDB found 0 allocation errors and 16 consistency errors in database 'XXXXX'.

    DBCC execution completed. If DBCC printed error messages,

    contact your system administrator.

    Thanks in advance.

  • http://sqlinthewild.co.za/index.php/2009/08/24/stats-blob-corruptions/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hi ,

    Why Cant you use the best option Backup and restore method using T-SQL instead of detach/attach method.

    1)You can perform DBCC CHECKDB on the source database or identity when was the last check db ran --this is to just ensure that the DB is in consistency state before you are going to restore on destination server or in the same server with other instance(like SQL 2005).

    2)make sure once the restore done run the DBCC UPDATEUSAGE .

    http://msdn.microsoft.com/en-us/library/ms188414.aspx

    Note ->There are Many ways you can perform the above activity.

    Best Regards,

    Rama Udaya

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

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