Microsoft KB Archive/814579

= PRB: You Receive Error Message: &quot;The log file for database 'Database Name' is full&quot; While Restoring a SQL Server 7.0 Database Backup on SQL Server 2000 =

Article ID: 814579

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



SYMPTOMS
When you back up a SQL Server 7.0 database, and you then restore the database on SQL Server 2000, the restoration process might fail, and you receive the following error message:

Microsoft SQL-DMO (ODBC SQL State: 42000)

The log file for database '' is full. Back up the transaction log for the database to free up some log space.

RESTORE DATABASE is terminating abnormally.

Converting database '' from version 515 to the current version 539.

Database '' running the upgrade step from version 515 to version 524.

Database '' running the upgrade step from version 524 to version 525.

Database '' running the upgrade step from version 525 to version 526.

Database '' running the upgrade step from version 526 to version 527.

Database '' running the upgrade step from version 527 to version 528.

Database '' running the upgrade step from version 528 to version 529.

Database '' running the upgrade step from version 529 to version 530.

Database '' running the upgrade step from version 530 to version 531.

Database '' running the upgrade step from version 531 to version 532.

Database '' running the upgrade step from version 532 to version 533.

Database '' running the upgrade step from version 533 to version 534.

Database '' running the upgrade step from version 534 to version 535.

Database '' running the upgrade step from version 535 to version 536.

Database '<Database Name>' running the upgrade step from version 536 to version 537.

<div class="cause_section">

CAUSE
This behavior may occur when the auto grow option for a transaction log is disabled for the SQL Server 7.0 database that was backed up.

<div class="workaround_section">

WORKAROUND
To work around this problem, enable the auto grow option of the transaction log file on SQL Server 7.0 before you perform the backup. To enable the auto grow option for the transaction log, use these steps:
 * 1) Log on to a computer where a SQL Server 7.0 database exists.
 * 2) Open SQL Server Enterprise Manager.
 * 3) Expand the SQL Server Group, and then click to select <SQL Server_Name>.
 * 4) Expand <SQL Server_Name>, and then click to expand the Databases folder.
 * 5) Right-click <Database_Name>, and then click Properties.
 * 6) Click the Transaction Log tab. Under the File Properties section, click to select Automatically grow file, and then click OK.

After you enable the auto grow option for the transaction log file on SQL Server 7.0, perform the backup of the database, and then restore it on a SQL Server 2000 server.

<div class="references_section">