Archiving Navision Database (SQL Server Option)

Dhaneesha

Hi

Need your help concerning archiving a Navision database historical data (2009 R2) based upon Sql server.

What are the procedures to do such a process as the database has become quite bulky. (Even if the process can be carried out directly on sql server)

Thanks a lot in advance.

ssingla

What do you mean by bulky?
What data you want to archive?

Dhaneesha

I want to archive data which exists for more than 3 years on the system, like for example sales header & line archive tables.

bbrown

Why do you want to do this? What do you mean by "bulky"? Can you provide some details on what data you want to archive and what do you mean by "archive"?