Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

space issue Expand / Collapse
Posted Friday, May 17, 2013 11:01 PM


Group: General Forum Members
Last Login: Yesterday @ 10:53 AM
Points: 453, Visits: 825
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


Group: General Forum Members
Last Login: Wednesday, March 9, 2016 3:48 AM
Points: 112, Visits: 297
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, April 2, 2016 6:21 AM
Points: 50, Visits: 503
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