Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-20 : 08:29:23
|
| Jaison writes "Dear Team,I had created a new database called 'maverick' and allotted 10gb for mdf file. After some days, I tried to reduce the datafile size to 4gb, But i was not able to do it.The error i had got is...Error 21335:[SQL-DMO]The new DBFile size must be larger than the current size.I just want to know whether it is possible to reduce the size of the datafile. If it is possible, How? if it is not possible Why?Please help me to solve this query." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-01-20 : 08:30:21
|
| Look in Books Online under "DBCC SHRINKFILE" and "DBCC SHRINKDATABASE". If you were simply changing the file size in Enterprise Manager, it won't work. There is a shrink operation available in EM, but it's easier to use the DBCC commands in Query Analyzer. |
 |
|
|
|
|
|
Decreasing data file size