Error 946: Cannot open database upgrade the database to the latest

I am trying to move a database from SQL Server 70 @. 70 compatibility level to
SQL Server 2000 @. 70 compatibility level.
But when execute restore stmt (cmd), I keep getting the errors:
Server: Msg 9002, Level 17, State 6, Line 2
The log file for database 'my_db' is full. Back up the transaction log for
the database to free up some log space.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Converting database 'my_db' from version 515 to the current version 539.
Database 'my_db' running the upgrade step from version 515 to version 524.
Database 'my_db' running the upgrade step from version 524 to version 525.
Database 'my_db' running the upgrade step from version 525 to version 526.
Database 'my_db' running the upgrade step from version 526 to version 527.
Database 'my_db' running the upgrade step from version 527 to version 528.
Database 'my_db' running the upgrade step from version 528 to version 529.
Database 'my_db' running the upgrade step from version 529 to version 530.
Database 'my_db' running the upgrade step from version 530 to version 531.
Database 'my_db' running the upgrade step from version 531 to version 532.
Database 'my_db' running the upgrade step from version 532 to version 533.
Database 'my_db' running the upgrade step from version 533 to version 534.
Database 'my_db' running the upgrade step from version 534 to version 535.
Error 946: Cannot open database upgrade the database to the latest version
Any idea, how I can restore w/o errors?Hi,
Looks like you do not have enough room in your hard disk in which the LDF
file resides. Could you identify the drive with more space and use
RESTORE DATABASE command with MOVE options to restore the database. See
Restore with Move option in Books online.
Thanks
Hari
SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:C74D6B5B-436D-4288-ABF3-31C835CC236B@.microsoft.com...
>I am trying to move a database from SQL Server 70 @. 70 compatibility level
>to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?|||Hi
For an Upgrade, SQL Server needs space in the transaction log to work. You
don't have enough.
On the SQL Server 7.0, before you make the backup, dump the log, grow the
transaction log to at least 10% of the database size, then do the backup and
then the restore the SQL Server 2000.
Regards
Mike
"Pari" wrote:
> I am trying to move a database from SQL Server 70 @. 70 compatibility level to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?|||Hi, you are right my log file did not have enough space, however, do you know
what these messages mean?
> > Database 'my_db' running the upgrade step from version 524 to version 525.
> > Database 'my_db' running the upgrade step from version 525 to version 526.
> > Database 'my_db' running the upgrade step from version 526 to version 527.
> > Database 'my_db' running the upgrade step from version 527 to version 528.
> > Database 'my_db' running the upgrade step from version 528 to version 529.
Does it mean its upgrading the DB from 70 compatibility to 80'
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> For an Upgrade, SQL Server needs space in the transaction log to work. You
> don't have enough.
> On the SQL Server 7.0, before you make the backup, dump the log, grow the
> transaction log to at least 10% of the database size, then do the backup and
> then the restore the SQL Server 2000.
> Regards
> Mike
> "Pari" wrote:
> > I am trying to move a database from SQL Server 70 @. 70 compatibility level to
> > SQL Server 2000 @. 70 compatibility level.
> >
> > But when execute restore stmt (cmd), I keep getting the errors:
> >
> > Server: Msg 9002, Level 17, State 6, Line 2
> > The log file for database 'my_db' is full. Back up the transaction log for
> > the database to free up some log space.
> > Server: Msg 3013, Level 16, State 1, Line 2
> > RESTORE DATABASE is terminating abnormally.
> > Converting database 'my_db' from version 515 to the current version 539.
> > Database 'my_db' running the upgrade step from version 515 to version 524.
> > Database 'my_db' running the upgrade step from version 524 to version 525.
> > Database 'my_db' running the upgrade step from version 525 to version 526.
> > Database 'my_db' running the upgrade step from version 526 to version 527.
> > Database 'my_db' running the upgrade step from version 527 to version 528.
> > Database 'my_db' running the upgrade step from version 528 to version 529.
> > Database 'my_db' running the upgrade step from version 529 to version 530.
> > Database 'my_db' running the upgrade step from version 530 to version 531.
> > Database 'my_db' running the upgrade step from version 531 to version 532.
> > Database 'my_db' running the upgrade step from version 532 to version 533.
> > Database 'my_db' running the upgrade step from version 533 to version 534.
> > Database 'my_db' running the upgrade step from version 534 to version 535.
> > Error 946: Cannot open database upgrade the database to the latest version
> >
> >
> > Any idea, how I can restore w/o errors?