SQL replication and Navision attain 3.60

cyberprimus

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?

regards
Daniel

ara3n

what you need to do is create the database with navision client first, then create your replication. Navision adds several objects in master db.

bbrown

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?

cyberprimus

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

Phenno

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...

bbrown

I feel Log Shipping would be a better solution.

cyberprimus

Cheers bbrown, currently testing log shipping.

thanks