Truncate/Shrink logfile while restoring fbk?

Luc_VanDyck · 2012-04-09

Excuse my ignorance, but is there a command available to truncate/shrink the logfile during a restore of a NAV backup? I'm restoring a customers backup (database is several 100 GB's) on an external 500GB disk. The database was created with the Simple recovery model, but this does not have an effect on the log when restoring a db. How can I truncate this log, so the restore can continue without running out of diskspace?

bbrown · 2012-04-09

The short answer is you can't. Since the data restore portion is a single transaction, you must have log space to support it. You could create additional log files elsewhere then remove them after the backup.

ndbcs · 2012-04-09

If you have multiple companies, only restore one at a time.

David_Singleton · 2012-04-09

Luc,

What I always do is first import objects and common data. Then go to all the big tables and deactivate the MaintainSQLIndex and MaintainSIFT.

Then import the company One at a time as mentioned above)

Then when complete import the table objects one by one to recreate the keys.

Luc_VanDyck · 2012-04-10

David Singleton wrote:

What I always do is first import objects and common data. Then go to all the big tables and deactivate the MaintainSQLIndex and MaintainSIFT.

Thx for this procedure. I'm doing it this way now.

David_Singleton · 2012-04-10

:thumbsup:

Howdy, Stranger!

Quick Links

Categories

Truncate/Shrink logfile while restoring fbk?

Answers