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: 2 days ago @ 4:53 AM
Points: 544, Visits: 2,116
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: Friday, December 12, 2014 10:09 AM
Points: 2,876, Visits: 5,201
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: Thursday, November 20, 2014 4:29 AM
Points: 3,559, Visits: 2,671
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: Today @ 9:47 AM
Points: 70, Visits: 185
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: Today @ 9:47 AM
Points: 70, Visits: 185
shrink DataFiles
Post #1453926
Posted Friday, May 17, 2013 4:50 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, December 24, 2014 11:12 PM
Points: 1,598, Visits: 1,156
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: 2 days ago @ 4:53 AM
Points: 544, Visits: 2,116
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, December 24, 2014 11:12 PM
Points: 1,598, Visits: 1,156
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 @ 2:39 PM
Points: 40,672, Visits: 37,137
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: 2 days ago @ 3:26 PM
Points: 2,355, Visits: 3,537
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)

Carl Sagan said: "There is no such thing as a dumb question." Sagan obviously never watched a congressional hearing!
Post #1454192
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse