Decreasing the size of a datafile |
 |
EXPERT RESPONSE FROM: Eric Brown

|
 |
|


|
| > |
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?
|
|
To continue reading for free, register below or login
To read more you must become a member of SearchSQLServer.com
|
|
');
// -->

|
|
 |

 |
 |
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
 |
 |
 |
|
 |
 |
 |
|
 |
|
 |