Skip to Content
avatar image
Former Member

how to increase database size actually in my company use MSSQL

Hi Expert,

Can any body tell me how to increase database size actually in my company use MSSQL but i dont know how to increase DB size. in MY PRD system it shows-

Data Files

No. of files-4

Total size(MB)-79,840

Alocated MB-79,825(99.98%)

Free MB-15(0.02%)

LOG

no of files-1

total size(MB)-2385

alocate MB-16

free-2342

recovery model-Full

Reuse wait resion-NOTHING

Now What i do give me suggessin

Thanks In Advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 08, 2010 at 07:02 AM

    Hi,

    see the note 363018, it describes in detail how to handle the files within SQL Server.

    Please ensure that all data files will have the same amount of freespace, after you have expanded them.

    Best regards

    Clas

    Edited by: Clas Hortien on Dec 8, 2010 8:02 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2010 at 12:33 PM

    Hi Raju,

    To increase the DB size, you need to increase the size of each data file of the DB .

    Please let us know the MS SQL version you are using. In MS SQL 2005 or 2008 , start the MS SQL studio> login > Select the Data Base > right click > Properties > Files > Initial Size . Here you see the size of data file already allocated . INcrease the size as you wish .

    Regards,

    Nibu Antony

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Rajuka,

      the size of your database is the sum of your datafiles. So if you want to increase the size of the database you have to increase the size of the datafiles. Apparently your datafiles have the size of 20GB, so the size of your database is 80GB. If you increase your datafiles to 25GB your database has the size of 100GB.

      In order to increase the size of your datafiles you can use the Management Studio as described by Nibu or you can use the provided sql code - it's up to you. There is another option called 'autogrow' that will increase the size of your datafiles automatically if needed. You can check in tcode DB02 on the Files tab (scroll to the right). Autogrow is not the recommended way to increase your datafiles - check with what Claas' wrote in his answer.

      Regards,

      Sven

  • avatar image
    Former Member
    Dec 20, 2010 at 01:58 PM

    Hi,

    MSSQL should manage it's space allocation automatically as long as you had enough space on disk drive and auto mode was on.

    Provided Max size of data file should be reasonably high.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 04, 2011 at 05:12 AM

    Hi,

    Before increase the size of datebase, you have to consider the Free space on that drive.

    After increase the size you cannot decrease the size.

    For increase size of database, follow the Nibu's' suggest path.

    so be careful.

    Thanks

    Ganesh

    Add comment
    10|10000 characters needed characters exceeded