Tuesday, February 21, 2012

Restore error - transaction log full

Hi

I'm trying to create a database (SQL Server 2000) using a backup file from another server (may have abeen an earlier version).
I get these errors on the restore:

The log file for database 'NEWDB' is full. Backup the transaction lg for the database to free up some log space.
RESTORE DATABASE is terminating abnormally.
Converting database 'NEWDB' from version 515 to the current version 539.
Database 'NEWDB' running the upgrade step from version 515 to version 524.
Database 'NEWDB' running the upgrade step from version 524 to version 525.
Database 'NEWDB' running the upgrade step from version 515 to version 524.
.......
Database 'NEWDB' running the upgrade step from version 536 to version 537.
The statement has been terminated.

If I try a 'dump transaction', I get:

Cannot open database 'NEWDB' version 536. Upgrade the database to the latest version.

Any ideas how I can increase the size of the transaction log to allow me to load it all?
Any ideas why the upgrades seem to stop at version 536? And how to complete them?

Thanks for any help

WendyIHi,
I think u should first backup the transaction log as specified in the error.
and the transaction log file limit might be restricted so it gives this error ,u might specify the unrestricted growth for the transaction log and after restoring the backup configure the growth of the transaction log as per the transaction s expected and required.
harshal.|||When I try to backup the log - I get:

1> backup log NEWDB to logbackup
2> go
Msg 946, Level 14, State 1, Server SERVERNAME, Line 1
Cannot open database 'NEWDB' version 536. Upgrade the d
latest version.
Msg 3013, Level 16, State 1, Server SERVERNAME, Line 1
BACKUP LOG is terminating abnormally.
1>

How do I get the database upgraded to the correct level?
What level should the database be at for SQL Server 2000?

Thanks
Wendy

No comments:

Post a Comment