Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    2

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

    Wendy

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    IHi,
    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.

  3. #3
    Join Date
    Nov 2002
    Posts
    2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •