space issue

Question

space issue

ramyours2003

SSChampion

Points: 12268
More actions
May 17, 2013 at 4:02 am

#277694

We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

ramyours2003 (5/17/2013)
We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive

Delete something! 😉

http://msdn.microsoft.com/en-us/library/ms189493.aspx

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

sqlnaive SSCoach Points: 17437 More actions · Answer 2

Lolz. Start taking backups and put a strategical purging mechanism in place for tables to purge old data. The data will be saved in the backups taken. No big deal. 🙂

sri2015 SSCrazy Points: 2780 More actions · Answer 3

sri2015

SSCrazy

Points: 2780

May 17, 2013 at 4:36 am

#1616109

shrink DataFiles

sri2015 SSCrazy Points: 2780 More actions · Answer 4

sri2015

SSCrazy

Points: 2780

May 17, 2013 at 4:37 am

#1616110

shrink DataFiles

Loundy SSCertifiable Points: 6080 More actions · Answer 5

Eugene Elutin (5/17/2013)
ramyours2003 (5/17/2013)
We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive
Delete something! 😉
http://msdn.microsoft.com/en-us/library/ms189493.aspx

ROFL - that put a smile on my face!

On a serious note - if you do go down the ShrinkFile route then make sure you reindex afterwards as you could run into fragmentation issues after it's finished.

[font="Times New Roman"]There's no kill switch on awesome![/font]

ramyours2003 SSChampion Points: 12268 More actions · Answer 6

ramyours2003

SSChampion

Points: 12268

May 17, 2013 at 8:10 am

#1616197

no space in data file , unable to shirnk.

Loundy SSCertifiable Points: 6080 More actions · Answer 7

ramyours2003 (5/17/2013)
no space in data file , unable to shirnk.

You need to purge some old data first - whether that is permanently deleting it or moving it to another db on another disk or what ever, you need to remove data from that db before you shrink it

[font="Times New Roman"]There's no kill switch on awesome![/font]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Delete data, add more space or move stuff to another drive.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ScottPletcher SSC Guru Points: 101119 More actions · Answer 9

If you have an (extremely) large table(s), compress them [if on Enterprise Edition], particularly if they are (almost) never used, such as log/audit tables, etc..

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

kevaburg SSCoach Points: 18131 More actions · Answer 10

ramyours2003 (5/17/2013)
We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive

SHRINK DATABASE, SHRINK FILE, add disks, partition the data in seperate databases onto other disks, check and rebuild/reorg Indexes, use compression, spread the databases to other servers.....the Options are endless....

but most of all, learn about what you are working with! Not just the databases but also the Software that they are hosted on!

sri2015 SSCrazy Points: 2780 More actions · Answer 11

if all db's .mdf files are stored in this drive, you need to do DB Maintenance for all databases except that DB

DB Maintenance

----------------

shrink database

Delete backup history

and job history

Rebuild index

then you will get some free space in Drive. so you can do Shrink database and Rebuild index for database, which you are getting space issue in .mdf file.

or finally if you have another drive in the same server, you better to add .ndf files.

pradeep.k 50453 Ten Centuries Points: 1380 More actions · Answer 12

check all the size of the table try to archival the old data