Solved

Disk Space Allocation

Posted on 1998-12-11
1
219 Views
Last Modified: 2012-05-04
I see how you can shrink a database, but how do you free up the space to the system once you've shrunk it?
0
Comment
Question by:jacknjill
1 Comment
 

Accepted Solution

by:
mhamra earned 20 total points
ID: 1092242
When you shrink your database, you only reduce the "db device" space used by the database, but not the "db device" size. You cannot shrink your devices. If no database is using a specific device, you can delete it and after that, you need to delete the .dat file to free up disk space. (Maybe the shrink operation free one or more devices that your database is not using)
If your database is installed in one device only or you cannot free some devices with the shrink operation, make a dump to a backup, check your backup, delete the database, delete the device and its asociated .dat file, and recreate the database in smaller devices.
Remember to create your database copying the same extents you did. You can see the "extents creation history" with sp_helpdb <db_name>
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question