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 |
imughal
Posting Yak Master
192 Posts |
Posted - 2007-09-06 : 06:36:44
|
My database MDF file growth is high and due to space limitation i have to shrink the MDF file so how do i do that |
|
Kristen
Test
22859 Posts |
|
AnjaliK
Starting Member
2 Posts |
Posted - 2011-04-10 : 11:20:20
|
Hi ,Plz tell me, how many hour to execute shrink database query.I have 300 GB Mdf file and Before two or three days,I have delete massive records. when I see its free space then it show to me its approx 50 GB .Now,approx 22 hrs is going on for executing this query and till now doesn't show to me free space of 1 GB at least but it increase the LDF file size to approx 2 MBand all of this there is too much fragmentation and can i run the job for defrag the Index and stop shrinking Query Because tomorrow is working .Thanks,Anjali |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
AnjaliK
Starting Member
2 Posts |
Posted - 2011-04-10 : 12:21:49
|
Hi,Thanks for your revert.I am taking 50 MB size for shrinking in increment and target for shrinking is 1000 MB.Now,Can I stop the query and run Job defrag the Index.If I stop then it impact it on my production Database Server?If yes, where?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|