Solved

Disk Space Allocation

Posted on 1998-12-11
1
214 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sqlquerystress - To test db performance 8 42
SQL - Update field defined as Text 6 17
T-SQL Default value in Select? 5 27
divide by zero error 23 16
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

809 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