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 |
|
doristan
Starting Member
12 Posts |
 Posted - 2008-06-17 : 01:29:05
|
| Hi all; i m using SQL 2000, i have a database with 86G mdf and 56G ldf size. i shrink the ldf and it reduced to 32M, however, i did not do anything on my mdf file, but the size of mdf has been reduced to 28G. just would like to check, is this correct?why is mdf size reduced when i only shrink my ldf? hope can help. thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-17 : 02:36:53
|
| How did you shrink the log file? If it was through the GUI, then I would guess that you clicked the OK button for the database shrink rather than only the ldf file shrink.Did you need the 50Gb or so from the mdf? Why was it this much larger than the space required? |
 |
|
|
doristan
Starting Member
12 Posts |
Posted - 2008-06-17 : 04:50:01
|
| yes, i did it through the GUI, but i did select the LDF file and i did not select the MDF file for the shrink.the actual space used for the DB is just 17G, but due to user inserted duplicate data and i have just done a clean up, the data size is still there. (i use sp_spaceused to check the size)i m just wondering why when i select shrink only the ldf file, the mdf file size will also reduced? |
|
|
|
|
|
|
Shrink ldf will reduce mdf size too?