Share
ReportThe G/L Entry table contains a field with a date value that cannot be used with SQL Server.
*This post is locked for comments
You’re offline. This is a read only version of the page.
The G/L Entry table contains a field with a date value that cannot be used with SQL Server.
*This post is locked for comments
Hi Ajifatou,
It seems your backup contains 0D (denotes date January 1, 0000) that is outside the valid range for a SQL DATETIME, a run-time error occurs. The earliest valid date in SQL Server for a DATETIME is 01-01-1753 00:00:00:000.
To solve the issue:
1. Restore the backup to a Native NAV database (*.fdb file).
2. Convert January 1, 0000 to 01-01-1753 00:00:00:000.
3. Backup again (*.fbk file).
4. Restore the backup to SQL version.
1) may be Check the regional options Advanced, Language for Non-unicode programs and ensure they are the same on backup and restore machines
2) Check the data format make sure both systems have same format and try
Hi Mouli, I have tried this before posting but currently my database is empty am trying to restore a database backup i took earlier and is giving that error during the restoration.
Please use try steps from Saurav's Blog
https://saurav-nav.blogspot.co.uk/2012/12/nav-2013-upgrade-part-iv-sql-migration.html
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (