Welcome to Sign in | Help

Re: Space available in SQL Server 2000

  •  02-26-2007, 10:29 AM

    Re: Space available in SQL Server 2000

    multumesc mult pt raspunsuri

    dar mai am o intrebare...

    credeti ca ar trebui sa maresc spatiul "reserved" pt aceasta baza ....se "poarta" asa ceva....daca da, cum fac lucrul asta si la cat ar trebui marita tinand cont de dimensiunea lui "data".....nu sunt prea apropiata ca valori?...astfel si "unused" space va fi mai mare

    name                fileid    filename                                  filegroup            size              maxsize    growth    usage    
    ---------------- ------ ----------------------------------------------------------------------------------------------------------------------------------------
    DBNAme_Data    1      C:\..data\DBNAme_Data.MDF    PRIMARY      2562752 KB    Unlimited    10%      data only
    DBNAme_Log     2      C:\..data\DBNAme_Log.LDF           NULL         833408 KB     Unlimited    10%       log only

    database_name    database_size      unallocated space 
    ---------------------------------------------------------------------------------
    DBNAme               3316.56 MB            421.85 MB


    reserved              data          index_size      unused            
    ------------ ------------------ ------------------ ---------------------------
    2130776 KB     2095584 KB    3600 KB      31592 KB

     

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems