SQL replication and Navision attain 3.60

cyberprimuscyberprimus Member Posts: 4
edited 2006-10-23 in Navision Attain
Hi everyone,

I'm testing SQL replication as another backup method. The replication seems to work fine. That is until I run the Navision Attain client 3.60 and came up with the following message

"The <database name> database on <server name> server does not contain Microsoft Navision Attain system objects and cannot be opened"

Anyone came across this error before?



  • ara3nara3n Member Posts: 9,255
    what you need to do is create the database with navision client first, then create your replication. Navision adds several objects in master db.
    Ahmed Rashed Amini
    Independent Consultant/Developer

    blog: https://dynamicsuser.net/nav/b/ara3n
  • bbrownbbrown Member Posts: 3,268
    What type of replication are you using. I would not recommend replication as a backup method. Why not use Log Shipping or move to SQL 2005 and use Database Mirroring?
    There are no bugs - only undocumented features.
  • cyberprimuscyberprimus Member Posts: 4
    I'm not really a SQL expert but I set up the replication to transactional, i.e. replicate every time there's a record being updated.

    The reason I'm testing the SQL replication is to see if we can get real time backup and restore method for our business. So in the event when our "live" server fails, we can switch the users to the backup server.

    SQL2005 will not be an option at this stage until I get $$ from the management :P
  • PhennoPhenno Member Posts: 630
    edited 2006-10-19
    I'm not sure does replication moves user accounts too but you have to be aware of the fact that you need same (or valid) accounts on backup db too...
  • bbrownbbrown Member Posts: 3,268
    I feel Log Shipping would be a better solution.
    There are no bugs - only undocumented features.
  • cyberprimuscyberprimus Member Posts: 4
    Cheers bbrown, currently testing log shipping.

Sign In or Register to comment.