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 |
|
andriancruz
Starting Member
38 Posts |
 Posted - 2008-09-29 : 01:32:24
|
| Dear to all guru'sIt is possible to reduce the .mdf files? cause I'm wondering the .mdf file size is growing fast, but my records is not much. i know the .ldf can be shrink and can reduce the size. but the .mdf I'm not sure if possible. I will highly appriciated the comment.Thank youAndrian |
|
|
lepeniotis
Yak Posting Veteran
75 Posts |
Posted - 2008-09-29 : 05:16:31
|
| Right click on the DB --> tasks --> Shrink --> File! file type: dataRegardsLepeniotisMSc Advanced Computing Science MSc Database ProfessionalSheffield Hallam UniversityMCP (70-229, 70-228)Industrial IT Engineer |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-29 : 08:32:52
|
| Donot shrink as it will cause fragmentation and disorganize data and index pages. Isn't it possible to increase disk space at any chance? |
|
|
|
andriancruz
Starting Member
38 Posts |
Posted - 2008-09-30 : 01:34:10
|
| Hi sodeep, Could you please tell me why if I use to shrink the data using lepeniotis advice. disorganize the data and index and the table will be defragmented.Thank you so much for the reply. I highly appreciated.Ward regards,Andrian |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-30 : 09:18:56
|
| Shrinking reshuffles index and data pages and they are not in order and result in Internal and External Fragmentation and you will see performance issues.Try to increase space instead. |
|
|
|
andriancruz
Starting Member
38 Posts |
Posted - 2008-10-01 : 00:03:45
|
| Thank you very much sodeep. now i understand.maybe after shrinking the datafile. i can execute rebuild index and use the dbcc defragment. what do you think?Thank you againWarm regards,Andrian |
|
|
|
|
|
|
Reduce Data Files