Import Datafile - Server unable to process request

Karenh

I am attempting to import datafile from live to test db. At 3%, I get error Server unable to process request. Application will now close. Any suggestions? I have done this several times. I deleted the existing company (slightly different name) in the test db in case space was an issue but that did not make any difference.

archer89

thx for the issue description and the solution.
check the sql database increase settings, best you set increase by 100mb.
shrink the database and/or the files.
you could also make a "hard shrink".
check, if there is enough space on the harddrive.

Karenh

I was able to successfully import another company, a company with few transactions, from live to test db, so it is not a matter of permissions.

Karenh

This is NAV 2015. I found the problem is that the transaction log file needed to be larger. I have increased it by 200 MB and I am now up to 8% before the process stops. This is taking my entire day. I wish the data file restore had a check point in it. I may not have enough disk space.

archer89

thx for the issue description and the solution.
check the sql database increase settings, best you set increase by 100mb.
shrink the database and/or the files.
you could also make a "hard shrink".
check, if there is enough space on the harddrive.