There is any tool available for archiving NAV data ?

manikandan · 2013-06-03

Hi All,
There is any tool available for archiving NAV data.Beceause DB Size is more than 400 GB. :?: :?: :?:

Regards,
Muthusubramanian.M

bbrown · 2013-06-03

manikandan wrote:

Hi All,
...DB Size is more than 400 GB...

Why is that a problem?

How long has the database been active for? Do you know what the annual growth is?

WHich tables occupy the largest amount of space? Let's say the top 10.

Marije_Brummel · 2013-06-03

I agree with Brian, it all depends how fast it grows and where the data is.

400GB is not "that" big.

Some tables in NAV like G/L are easy to compress/archive.

Other tabledata can be simply deleted such as posted sales and purchase documents.

manikandan · 2013-06-04

Hi Mark Brummel,
Thanks for your reply.How can i compress/archive G/L Entry Table.
But in this DB attached with LS Retail.

Thanks ,
Muthusubramanian.M

Marije_Brummel · 2013-06-04

Type Compress in the searchfield of the RTC and you'll be in the menu.

But contact LS Retail first if they support this.

There is any tool available for archiving NAV data ?

Comments

Categories