SQL Server - Database Size

rkaufmann
rkaufmann Member Posts: 71
edited 2005-04-16 in NAV/Navision Classic Client
Hi,

maybe this is a stupid question, but I have absolutly no know how with SQL Servers.

We are running 3.70 on an SQL Server and have a database utilisation of about 95%.

On a native Database I can expand the DB by using "File => Databse => Expand".

On SQL this is not availible.
How do I expand an SQL databse?

Comments

  • wochm
    wochm Member Posts: 26
    Hello!
    You can do it using Enterprise Manager. But usually SQL databases expand by itself, are auto expandable. Of course it depends on its configuration.

    Pozdrawiam/Best Regards
    Marcin Woch
    _____________________
    "ANTEI" Woch Marcin
    email: marcinwoch@wp.pl
    tel.: (+48608) 39 46 29
    Poland
  • kine
    kine Member Posts: 12,562
    If you want to have optimum performance, do not use auto expand. Rather set up jobs to inform you that you have low free space and expand files manually. You can do it through File-Database-Alter-Database Files-Size...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • wochm
    wochm Member Posts: 26
    I agree. But I mentioned about such a possibility.

    Pozdrawiam/Best Regards
    Marcin Woch
    _____________________
    "ANTEI" Woch Marcin
    email: marcinwoch@wp.pl
    tel.: (+48608) 39 46 29
    Poland

Categories