Error While Restoring Backup in NAV

chandrurec

Hi all,

I am getting a error as follow when restoring a backup in finsql in NAV.

The following SQL Server error(s) occurred while accessing the Sales Invoice Line table:

1105,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'dbo.ABC Pvt Ltd$Sales Invoice Line1000000113'.'ABC Pte Ltd$Sales Invoice Line1000000113$0' in database 'NewNAV401' because the 'Data Filegroup 1' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

If anyone know how to rectify this problem , kindly let me know.

Thanks in advance.

Regards,
chandru.

bbrown

The message tells you exactly what the problem is and how to fix it.

1. The datafile is too small
2. AutoGrow is either disabled or the file has reached it's maximum allowed size.


Create the database large enough to handle the restore.

Chinmoy

Or may be the datafile is placed in a disk which does not have any more free space for the file to grow.

santoshmkcet

Kindly suggest How to enable Auto Grow.

Since I am using SQl Server 2008 database

geordie

Did you check also in NAV to have "Unrestricted Growth" flagged and "File Growth" evaluated?