SQL Server - Database Size

rkaufmannrkaufmann Member Posts: 71
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

  • wochmwochm 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
  • kinekine 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.
  • wochmwochm 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
Sign In or Register to comment.