Killing a shrinking dbfile process


I have a db with a mdf and ldf. And the mdf file size is around 350 gba and nearly 60% of its having free space and occupied the complete drive. Someone from our team had modified the filegrowth parameters from standard set by us. Now we had started the shrinking of mdf file from gui. Shrink process is running for the past 18 hours and its completed only 60%. If I kill the shrink process now will it have any impact on my database. Please resond asap.

Thanks ChandraMohan

more ▼

asked May 06, 2010 at 05:26 AM in Default

avatar image

118 6 7 9

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Yes, it's safe to kill it.

But why would you want to shrink it anyway? There's certainly no problem in having lots of free space in your data file.

more ▼

answered May 06, 2010 at 05:30 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

does it require any downtime for the db

May 06, 2010 at 05:33 AM Chandoo5599

@Matt - sort of depends on what else needs the drive - OS, backups, other dbs ... ?

May 06, 2010 at 05:53 AM Fatherjack ♦♦

@Fatherjack - I'm from the old school whereby database drives should be for databases - certainly no place for backups and definitely not the O/S... other DBs though... could be...

May 06, 2010 at 06:33 AM Matt Whitfield ♦♦

@Matt, certainly with you on that but was expecting the worst!

May 06, 2010 at 06:38 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 06, 2010 at 05:26 AM

Seen: 1502 times

Last Updated: May 06, 2010 at 05:26 AM

Copyright 2018 Redgate Software. Privacy Policy