March 25, 2011 at 9:52 am
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.
March 25, 2011 at 9:59 am
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
September 18, 2011 at 3:34 am
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