x

Killing a shrinking dbfile process

Hi,

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

Chandoo5599 gravatar image

Chandoo5599
118 6 7 7

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

1 answer: sort oldest

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

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x37

asked: May 06, 2010 at 05:26 AM

Seen: 1309 times

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