Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

space issue Expand / Collapse
Author
Message
Posted Friday, May 17, 2013 4:02 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 9:11 AM
Points: 663, Visits: 2,526
We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive
Post #1453917
Posted Friday, May 17, 2013 4:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, August 24, 2015 9:31 AM
Points: 2,926, Visits: 5,410
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!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1453918
Posted Friday, May 17, 2013 4:10 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, July 24, 2015 8:43 AM
Points: 3,600, Visits: 2,723
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.
Post #1453919
Posted Friday, May 17, 2013 4:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 26, 2015 5:31 AM
Points: 94, Visits: 248
shrink DataFiles
Post #1453925
Posted Friday, May 17, 2013 4:37 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 26, 2015 5:31 AM
Points: 94, Visits: 248
shrink DataFiles
Post #1453926
Posted Friday, May 17, 2013 4:50 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 6, 2015 8:41 AM
Points: 1,600, Visits: 1,167
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.


There's no kill switch on awesome!
Post #1453929
Posted Friday, May 17, 2013 8:10 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 9:11 AM
Points: 663, Visits: 2,526
no space in data file , unable to shirnk.
Post #1454027
Posted Friday, May 17, 2013 8:44 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 6, 2015 8:41 AM
Points: 1,600, Visits: 1,167
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


There's no kill switch on awesome!
Post #1454046
Posted Friday, May 17, 2013 9:09 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:50 AM
Points: 42,777, Visits: 39,705
Delete data, add more space or move stuff to another drive.


Gail Shaw
Microsoft Certified Master: SQL Server, MVP
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

Post #1454055
Posted Friday, May 17, 2013 2:49 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:53 AM
Points: 3,046, Visits: 4,665
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)

"If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them." James Blackburn, in closing argument in the "Fatal Vision" murders trial
Post #1454192
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse