T-SQL Restore

  • PBirch

    SSCrazy Eights

    Points: 8483

    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

    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: 8483

    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: 119694

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

    Andy

Viewing 4 posts - 1 through 4 (of 4 total)

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