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