T-SQL Restore

• PBirch

  SSCrazy Eights

  Points: 8493

  More actions

  October 9, 2001 at 12:52 pm

  #57512

  Ok. A basic T-SQL restore for a SQL Server 7 database. The question is it returns:

  > Database 'TOLNONNTS' running the upgrade step from

  > version

  > > 515 to version 524.

  > > Database 'TOLNONNTS' running the upgrade step from

  > version

  > > 524 to version 525.

  What are the versions?

  Thanks,

  patrick

  Patrick Birch

  Quand on parle du loup, on en voit la queue

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  October 9, 2001 at 3:29 pm

  #418770

  It looks the the restore of a file to a newer version of SQL Server. Is this a 7.0 file being restored to SQL Server 2000?

  David

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

• PBirch

  SSCrazy Eights

  Points: 8493

  More actions

  October 9, 2001 at 4:21 pm

  #418775

  That's what I thought, but no. It's strictly a SQL Server 7 box.

  Version 5.15 is probably the database engine, but I'm just not sure what it's doing running upgrade steps in a basic restore statement.

  Thanks,

  Patrick Birch

  Quand on parle du loup, on en voit la queue

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 9, 2001 at 5:04 pm

  #418777

  I think you'll see this as a result of a service pack thats been applied since the backup.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter