SQL Replication of Navision Database 2009

Business Central/NAV Technical Forum
1

Hello Guys,

I have installed Navision 2009 database with SQL server 2008 Standard Version. Now I am trying to replicate this database on the other server. The replication is not working fine for the tables having sum indexed view… It is given me the following error message.

“Noexpand on object …”

For most of the table the replication is working fine accpet those table where i have indexed View…

Any solution boss…

tnks
Rajneesh

2

Hi Rajnees

Take bakup of DB1from sql. while taking backup it will ask you to maintain views and indexes.

now create a new DB in your second server name it as DB2. now restore the backup[Which you taken from the DB1] on the DB2 at the back end.

Thanks

Jerome Marshal.J