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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-04-05 : 01:42:58
|
| hi I have changed the initial size of the model DB , now I want to change it again , but I want to make it smaller than the one it is currently can i do that When I go the EM & try changing the file size it says :- The new DBFile size must be larger than the current size Regardsaki |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-05 : 02:05:05
|
| Shrink it?Kristen |
 |
|
|
EASYSQL
Starting Member
10 Posts |
Posted - 2006-04-05 : 10:36:44
|
| Use the DBCC cmd DBCC SHRINKFILE(SalesDB_Data)but you can also select the auto shrink option in the DB properties which will shrink the database automatically if needed |
|
|
|
|
|
|
Model Db