There is any tool available for archiving NAV data ?

manikandan

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


Regards,
Muthusubramanian.M

bbrown

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

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

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

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

But contact LS Retail first if they support this.