Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Database upgrade

Author  Topic 

dewacorp.alliances

452 Posts

Posted - 2008-03-02 : 14:43:56
Hi all

We've restored a database from SQL2000 SP3a and into SQL2005 SP2.

When it restored through a TSQL restore, the message is saying below. Can someone explain this numbering between 539 and 611? Is this some sort internal versioning or something? That numbering doesn't corresponding the SQL version. ?!?!

Thanks

5 percent processed. 10 percent processed. 15 percent processed. 20 percent processed. 25 percent processed. 30 percent processed.
35 percent processed. 40 percent processed. 45 percent processed. 50 percent processed. 55 percent processed. 60 percent processed. 65 percent processed. 70 percent processed. 75 percent processed. 80 percent processed. 85 percent processed. 90 percent processed.
95 percent processed. 100 percent processed.
Processed 12042832 pages for database 'XXXXXX55', file 'XXXXXX55' on file 1.
Processed 37 pages for database 'XXXXXX55', file 'XXXXXX55_Log.ldf' on file 1.
Converting database 'XXXXXX55' from version 539 to the current version 611.
Database 'XXXXXX55' running the upgrade step from version 539 to version 551.
Database 'XXXXXX55' running the upgrade step from version 551 to version 552.
Database 'XXXXXX55' running the upgrade step from version 552 to version 553.
Database 'XXXXXX55' running the upgrade step from version 553 to version 554.
Database 'XXXXXX55' running the upgrade step from version 554 to version 589.
Database 'XXXXXX55' running the upgrade step from version 589 to version 590.
Database 'XXXXXX55' running the upgrade step from version 590 to version 593.
Database 'XXXXXX55' running the upgrade step from version 593 to version 597.
Database 'XXXXXX55' running the upgrade step from version 597 to version 604.
Database 'XXXXXX55' running the upgrade step from version 604 to version 605.
Database 'XXXXXX55' running the upgrade step from version 605 to version 606.
Database 'XXXXXX55' running the upgrade step from version 606 to version 607.
Database 'XXXXXX55' running the upgrade step from version 607 to version 608.
Database 'XXXXXX55' running the upgrade step from version 608 to version 609.
Database 'XXXXXX55' running the upgrade step from version 609 to version 610.
Database 'XXXXXX55' running the upgrade step from version 610 to version 611.
RESTORE DATABASE successfully processed 12042869 pages in 999.897 seconds (98.665 MB/sec).

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-02 : 15:20:16
Sql upgraded the db from build 539 to 611 step by step.
Go to Top of Page
   

- Advertisement -