Navision Restore Question

megawavez

Hi,

We are using Nav 3.7a with SQL 2000. I'm trying to restore a 32gb database onto a 48gb drive. On our runtime database we use "Simple" transaction logging so there is no problem with the log file. Unfortuantely, the restore creates a log file that is about 30% larger than the actual database file and the two won't fit on the 48gb partition before I can shrink the database. Is there anyway to perform the restore without producing a log file? Thanks,

Mega

DenSter

No unfortunately that is not possible. The restore operation is seen as one transaction, so you're going to need the disc space to create the database, and using a NAV backup the log file will grow that much. I've seen it grow by as much as 2-3 times as big as the database. Another option is to take a SQL Server backup and restoring that. Restoring that won't need to have the initial log file.

megawavez

DenSter wrote:

No unfortunately that is not possible. The restore operation is seen as one transaction, so you're going to need the disc space to create the database, and using a NAV backup the log file will grow that much. I've seen it grow by as much as 2-3 times as big as the database. Another option is to take a SQL Server backup and restoring that. Restoring that won't need to have the initial log file.

Ah.. too bad. Thanks for the help !

Mega

David_Singleton

From what you are saying, this can not be a live system, so I assume you are just restoring a local test DB on your laptop. In that case, and since it is such a small db, just plug in a USB drive and put the log there.

bbrown

megawavez wrote:

Hi,

...On our runtime database we use "Simple" transaction logging so there is no problem with the log file...
Mega

Why? :?:

Why would you not use full recovery and implement transaction log backups on a live system?