QUESTION POSED ON: 21 February 2006
I had created a database named "maverick" and allocated a size of 6 GB for datafile(.mdf) and 1 GB for logfile(.ldf). But after that, due to some disk space re;ated reason, I tried to decrease the datafile size from 6 GB to 2 GB. But I am not able to do it.
Is it possible to decrease the size of a datafile in SQL Server 2000? If it is possible, how? If it is not possible, why?
|