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 11:01 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 6:13 AM
Points: 307, Visits: 475
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!
Post #1454227
Posted Sunday, May 19, 2013 1:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 29, 2014 9:34 AM
Points: 66, Visits: 170
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.


Post #1454316
Posted Monday, May 20, 2013 8:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 3:28 AM
Points: 40, Visits: 349
check all the size of the table try to archival the old data
Post #1454558
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse