Share via

ask about sql server

aka aran 20 Reputation points
2025-08-11T15:38:44.13+00:00

now my sql data is 100gb + use in microsoft navision use 5 year database setting is basic and auto glow unlimited can you tell me to make small database how to do

thank you

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
0 comments
Answer accepted by question author
  1. Erland Sommarskog 127.7K Reputation points MVP Volunteer Moderator
    2025-08-11T20:40:24.37+00:00

    I'm tempted to say that by today's standards 100 GB is a fairly small database. At least it is not frightingly big.

    Anyway, do you have a lot of free space in the database? Else you need to delete/archive old data. How you would do that, requires knowledge about the system, so you would need to ask in a Navision forum.

    Then again, where I live, company are by law required to keep bookkeeping records for at least seven years. The law may be different in your country, but I think you check this with your business side before you start any data cleansing.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.