shrinking of database

[Raman Viswanathan]

i havae a database size of 1000mb with used as 507.50 and unused as 492.50. i tried with commands like dbcc shrink file and dbcc shrink database but i could not get the result as what i need. I need to shrink in such a way that it should have 25% of the used space as free space. could any one help

[Deepak]

(I cannot say it authoratively, but.. ) It seems one cannot shrink a database beyond the size which the DB had been created with. If I create a DB at 100MB and use only 1MB, I cannot take the DB size below 100MB. If I increase it to 1000MB sometime, I can get it to 100MB, but not beyond that.
Deepak.



------------
Raman Viswanathan at 12/30/99 12:16:51 PM

i havae a database size of 1000mb with used as 507.50 and unused as 492.50. i tried with commands like dbcc shrink file and dbcc shrink database but i could not get the result as what i need. I need to shrink in such a way that it should have 25% of the used space as free space. could any one help

[Raman Viswanathan]

but is the use of dbcc database shrink this is tried when the data is taken a backup as suggested by microsoft. is there any other solution for this

------------
Deepak at 12/30/99 4:39:01 PM

(I cannot say it authoratively, but.. ) It seems one cannot shrink a database beyond the size which the DB had been created with. If I create a DB at 100MB and use only 1MB, I cannot take the DB size below 100MB. If I increase it to 1000MB sometime, I can get it to 100MB, but not beyond that.
Deepak.



------------
Raman Viswanathan at 12/30/99 12:16:51 PM

i havae a database size of 1000mb with used as 507.50 and unused as 492.50. i tried with commands like dbcc shrink file and dbcc shrink database but i could not get the result as what i need. I need to shrink in such a way that it should have 25% of the used space as free space. could any one help

[Deepak]

Hey, I could reduce the size of my db to a size lower than the one with which the db was created. I used dbcc shrinkfile. What does it do in your case ?



------------
Raman Viswanathan at 12/30/99 4:42:39 PM

but is the use of dbcc database shrink this is tried when the data is taken a backup as suggested by microsoft. is there any other solution for this

------------
Deepak at 12/30/99 4:39:01 PM

(I cannot say it authoratively, but.. ) It seems one cannot shrink a database beyond the size which the DB had been created with. If I create a DB at 100MB and use only 1MB, I cannot take the DB size below 100MB. If I increase it to 1000MB sometime, I can get it to 100MB, but not beyond that.
Deepak.



------------
Raman Viswanathan at 12/30/99 12:16:51 PM

i havae a database size of 1000mb with used as 507.50 and unused as 492.50. i tried with commands like dbcc shrink file and dbcc shrink database but i could not get the result as what i need. I need to shrink in such a way that it should have 25% of the used space as free space. could any one help

[Raman Viswanathan]

how long does it takes it to shrink. I have tried but it has not shrunk


------------
Deepak at 12/30/99 4:53:47 PM

Hey, I could reduce the size of my db to a size lower than the one with which the db was created. I used dbcc shrinkfile. What does it do in your case ?



------------
Raman Viswanathan at 12/30/99 4:42:39 PM

but is the use of dbcc database shrink this is tried when the data is taken a backup as suggested by microsoft. is there any other solution for this

------------
Deepak at 12/30/99 4:39:01 PM

(I cannot say it authoratively, but.. ) It seems one cannot shrink a database beyond the size which the DB had been created with. If I create a DB at 100MB and use only 1MB, I cannot take the DB size below 100MB. If I increase it to 1000MB sometime, I can get it to 100MB, but not beyond that.
Deepak.



------------
Raman Viswanathan at 12/30/99 12:16:51 PM

i havae a database size of 1000mb with used as 507.50 and unused as 492.50. i tried with commands like dbcc shrink file and dbcc shrink database but i could not get the result as what i need. I need to shrink in such a way that it should have 25% of the used space as free space. could any one help