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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, August 9, 2014 2:03 PM
Points: 521, Visits: 2,010
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: 2 days ago @ 8:36 AM
Points: 2,836, Visits: 5,066
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: Tuesday, August 5, 2014 5:20 AM
Points: 3,546, Visits: 2,651
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 31, 2014 9:48 AM
Points: 66, Visits: 171
shrink DataFiles
Post #1453925
Posted Friday, May 17, 2013 4:37 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 31, 2014 9:48 AM
Points: 66, Visits: 171
shrink DataFiles
Post #1453926
Posted Friday, May 17, 2013 4:50 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 5:16 PM
Points: 1,597, Visits: 1,151
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, August 9, 2014 2:03 PM
Points: 521, Visits: 2,010
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: Wednesday, August 13, 2014 5:16 PM
Points: 1,597, Visits: 1,151
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 @ 11:31 AM
Points: 42,756, Visits: 35,848
Delete data, add more space or move stuff to another drive.


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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:28 PM
Points: 2,027, Visits: 3,023
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)
"In America, every man is innocent until proven broke!" Brant Parker
Post #1454192
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse