Attach SQL 7 DB files in SQL Server 2000

• rajendra-232973

  Grasshopper

  Points: 18

  More actions

  March 2, 2006 at 11:18 pm

  #152799

  Hi All,

  I am trying to attach SQL 7 Database files into SQL Server 2000 server and I am getting the following error.

  Converting database 'Acct_Review_Ddb' from version 526 to the current version 539.

  Database 'Acct_Review_Ddb' running the upgrade step from version 526 to version 527.

  Location:  upgraddb.cpp:1436

  Expression:  PageId_FIRST_SYSOBJECTS_AFTER_527 == newPageId

  SPID:   59

  Process ID:  800

  Connection Broken

   please help me out in this.

   

  Thanks & Regards,

   

  Rajendra.

   

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  March 3, 2006 at 5:23 am

  #624561

  Perhaps the files are corrupted?  Try running DBCC CHECKDB from SQL 7 and let it fix any errors - then try the attachment/upgrade again.