Post reply

Datafile Size

  • November 21, 2006 at 7:29 am

    #61984

    I currently have an *.mdf that is approximately 9 gb that is running out of room. I need to increase the size of the file and I wonder if there is a limit to the size of a datafile?

    Thanks.

  • November 21, 2006 at 7:38 am

    #673206

    Gleen,

    You can happily increase the file from 9GB. SQL Server can manages TB of data. To manage your space on discs, you may consider to split your data into multiple data files [ie. adding .ndf]

    Regards

    Utsab Chattopadhyay


    CDBA

  • November 21, 2006 at 7:47 am

    #673210

    Thanks.

  • November 21, 2006 at 8:20 am

    #673228

    IIRC the server can hold around 32676 databases where all of those could containt ±1 M terabytes of data. That's more or less 32 000 000 000 000 000 000 000 Bytes of data.  Anyone want to buy me a SAN for that .

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply