Questions tagged [shrink]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
1k views

How to shrink qcow2 disk safely?

This is what my guest looked like i shrinked the C partion in the guest in the windows 10 guest , made sure that the unallocated space is on the right most side. then, i did this sudo qemu-img ...
munish's user avatar
  • 151
0 votes
1 answer
1k views

BTRFS resize - free space not available to use

I'm trying to shrink BTRFS partition and create new EXT4 partition with that free space. I did btrfs filesystem resize -5g / Now I have this (notice Device slack equals what I shrinked): ...
PetrK's user avatar
  • 53
0 votes
0 answers
200 views

Windows Server - how to shrink partition on GPT disk from the front?

I'm looking for a way to shrink a partition on a GPT disk from the front on production servers. With diskpart it's only possible to shrink the space from the end. Ideally while running
Carsten Krüger's user avatar
2 votes
0 answers
458 views

resize2fs shrinking very slow

I tried to shrink a 60TB ext4 to 50TB and it takes about one week to finish. I know that should take much time but it's very slow even my disks underlying are RAID0. After some research, it seems ...
yayaya's user avatar
  • 31
0 votes
0 answers
450 views

Centos 7 - Shrink size of LVM Partition

I have a Centos 7 VM which was built from an OVA template. I have it running under Virtualbox. Issue I have is the VM has a dynamic disk of 200G - but only 4 Gb used. I want to shrink the partition to ...
Adam's user avatar
  • 11
0 votes
0 answers
266 views

Sql Server 2017 - Cannot shrink transaction log file, blocked by LOG_BACKUP status

Last week my sql server 2017 instance (running on windows server 2016) ran out of space, filling the disk completely up with a 190GB transaction log file. Luckily this was on a cloud instance, so I ...
Scriptonaut's user avatar
1 vote
1 answer
118 views

shrink LVM (not XFS) to use for guest nodes (KVM)

I have /homemountpoint (Type=LVM). how can I reduce/home` from 418G to 200G and use remaining disk space for guest(KVM) Node? because XFS can not be shrunk (). localhost home]$ lsblk NAME ...
AAserver's user avatar
-1 votes
2 answers
1k views

Shrink Windows 10 ISO to a minimum

I want to run Windows 10 on a virtual machine for automated testing. I only need Edge or IE installed and want the .iso file size to be as small as possible. Is there a way to shrink the image by ...
LoadRunner's user avatar
1 vote
2 answers
358 views

Shrinking overprovisioned thin disks

We have a VCenter with some data storages, one of them is 10 TB. The issue is that the former sysadmins created many VM's with thin provisioned disks of 8 TB. Right now, the provisioned storage is ...
gsantovena's user avatar
5 votes
2 answers
3k views

Google compute engine - shrinking disks

I have a 5TB HD and I want to shrink it to 2TB. I use Google Compute Engine PaaS. How can I do that? Can you suggest any tools to perform this manually if this cannot be solved by Google's tools?
Eran Betzalel's user avatar
0 votes
0 answers
858 views

Shrinking and extending disks on Server while running?

So I have a server with Hyper-V and a Drive C: (OS) and D. Drive D stores all of the VHDs that I run. Drive C shows up as Disk 0, and D as Disk 1 under Disk Management respectively. Now Drive D gets ...
user3038614's user avatar
2 votes
1 answer
3k views

Hyper-V VHDx Compacting & SIzing Issue - No Minimum Size, Unable to Shrink

Trying to recover ~450GB unallocated space from a VHDx total filesize. Thanks for taking a look at this issue: Hyper-V Server 2012. Dynamic VHDx (we'll call it disk2.vhdx) with a file size of 1.5TB ...
TSga's user avatar
  • 121
2 votes
3 answers
3k views

Resize RAID partition with GPT partition layout, without LVM

OK so I am a freelance sysadmin. I was asked to resize root partion (/) because it was 20Gb and /home was 3Tb. What I wasn't told is that the server is using RAID and GPT, so I can't use fdisk but ...
thms0's user avatar
  • 71
2 votes
2 answers
31k views

SQL Server Transaction Log maximum file size

I have several databases, all in Simple recovery mode. There have been previous concerns about the log file sizes and I have shrunk them all using Management Studio's Shrink task. I have also placed a ...
Mike Richards's user avatar
2 votes
0 answers
631 views

shrink live mdadm partition with LVM

My goal is to shrink an mdadm RAID 1 partition while the system is running. I have to disks sda and sdb, which build my two RAID partitions md0 and md1. On md1 I use LVM, md0 is the /boot partition. I ...
user2323470's user avatar
2 votes
1 answer
9k views

Resizing partition with DiskPart using desired and minimum options is unsuccessful

I have a few systems I want to shrink the primary (and only) partition to about half of the disk and then create a new partition in the newly available space. The disks are 500GB. I want to script it, ...
Aaron's user avatar
  • 21
0 votes
1 answer
6k views

esxi 5.1 (free) reduce vmdk size (not zero the data, reduce size by a certain amount) [duplicate]

I have set 100GB as the limit of my VMDK. I can reduce the size by using the vmkfstools -k my.vmdk What I would really like to do is take 20GB off the thick size of the disk. Any advice? I would ...
Lance's user avatar
  • 281
0 votes
2 answers
24k views

Is it safe to shrink tempdb.mdf in MS SQL Server?

Hej, my TEMPDB.mdf grew up to 42GB on MS SQL Server 2005 installed on Windows Server 2003. Last date change is 31/01/2013 at night. So, I wonder whether this is ok to shrink it?
Volodymyr Molodets's user avatar
0 votes
2 answers
7k views

What's the difference between shrinking files or database in SQL Server?

I need more space in my development environment and need to shrink my database (or files) in SQL Server. Should I chose "shrink files" or "shrink database" to free most disk space?
Benny Skogberg's user avatar
1 vote
3 answers
6k views

Shrink a Windows VM in XenServer

I faced a problem. I deployed a VM by size of 500GB on Citrix XenServer and now I want to shrink it, because I don't have enough space for snapshots. Now I want to perform an export/import to do this. ...
Mehdi's user avatar
  • 80
2 votes
2 answers
13k views

How to shrink Linux partition (sda2, type is Linux LVM)

I have sda disk with 2 partitions. The second partition sda2(which is LVM) is 1.4TB in size and want to shrink to 50GB. I reduced Logical volume to 50GB but when I run vgdisplay it shows Free PE / ...
kupa's user avatar
  • 381
4 votes
2 answers
13k views

SQL Server: How to shrink FileStream files?

For a project, I'm using a SQL Server 2008 R2. One table has a filestream column. I've made some load tests, and now the database has ~20GB used. I've empty tables, except several(configuration ...
J4N's user avatar
  • 167
1 vote
2 answers
913 views

Is it a good idea to compress a MS SQL database backup?

Quick question! I heard that we should never shrink our databases. However, does the same rules apply to compressing our SQL backup? Thanks
user1034912's user avatar
  • 1,364
7 votes
2 answers
18k views

VMplayer Virtual Disk Shrinking/Compacting/Defragmenting

I am using VMplayer on Windows 7 and 2008 R2. Inside the guest OS, in VMware tools, there is a "Prepare to shrink" option on the "Shrink" tab. In the host VMplayer menu there is "Defragment" and ...
fupsduck's user avatar
  • 173
1 vote
1 answer
58 views

Individual Customer Backup from Multi Customer DB

We have a multi customer database, that's about 95gb in size. One of the customers is requesting a monthly backup of their data. We have a script that strips out all records from all tables that are ...
HarleyP's user avatar
  • 13
2 votes
1 answer
8k views

Should I consider shrinking or truncating a big LDF file?

I apologize for asking a question that gets asked a lot. I have a database that has an 80GB LDF file. MDF is 230MB. I have never shrunk or truncated the database. I do not know much about shrink ...
obautista's user avatar
  • 149
6 votes
6 answers
16k views

Which version of ZFS allows shrinking of a pool?

I found a list of versions and their Solaris release numbers http://download.oracle.com/docs/cd/E19253-01/819-5461/appendixa-1/index.html I know that you can grow a pool by replacing drives with ...
700 Software's user avatar
  • 2,273
1 vote
2 answers
2k views

Microsoft SC VMM 2008 R2 doesn't have option to compact virtual hard disk

I can't figure out how to shrink a VHD using Microsoft System Center Virtual Machine Manager 2008 R2. Viewing the article Shrink your VHD size seems like this would be simple to do. However I don't ...
Chris Marisic's user avatar
2 votes
1 answer
3k views

How do I shrink an EBS volume on Windows Server 2008?

I have a Windows Server 2008 instance on EC2. I need to shrink one of the drives (non-root) to a certain amount. Is there are well defined way of doing it? Thanks
Wajih's user avatar
  • 235
4 votes
3 answers
6k views

Shrink SQL Server data file, but not all at once?

I have a database file that's currently 150GB, but only 75GB is being used - it's because I moved all the indexes (the other 75GB) to a new data file. I'd like to reclaim at least part of the space ...
SqlRyan's user avatar
  • 916
13 votes
3 answers
23k views

How to restore a SQL Server database and shrink its files at the same time?

Let's say I have a SQL Server database whose data files have been created with an initial size of 100 GB, but it only contains 10 GB of data. A database backup will then be only 10 GB in size. I want ...
Massimo's user avatar
  • 71.2k
1 vote
2 answers
368 views

How to truncate SQL Server log file

I tried to shink database log file but it is still huge. My database is 200mb and log is 30Gb USE [databasename]; BACKUP LOG [databasename] WITH TRUNCATE_ONLY; DBCC SHRINKFILE ('databasename_log', 1, ...
agassan's user avatar
  • 13
3 votes
3 answers
11k views

Ways of estimating the time to perform a database shrink on SQL Server

Is there a way to approximate how long a shrink will take on a SQL Server database? Are there tools available that could provide some guesstimate? We have very large databases, so it would be good ...
Fuzzy Purple Monkey's user avatar
0 votes
2 answers
3k views

how to consolidate multiple log files into one ldf file in sql2000

I'm in the process of copying databases from SQL 2000 to a 2008 instance on another server using DETACH, copy windows file to 2008 server, then finally ATTACH. I've come to a database where the LOG ...
DaniellaMercuryFan's user avatar
3 votes
3 answers
672 views

Shrink Sql Server database

My SQL Server 2008 database file (.mdf) file is nearly 24 MB but the log file grown upto 15 GB. If I want to shrink database what are the important points to take into consideration? Will shrink ...
user avatar
1 vote
4 answers
1k views

Shrink Partition on Production Server

Our production server was only set up with one large partition. I have set up a standby server and properly partitioned it. Now the boss wants the production environment's partition shrunk. It is an ...
Campo's user avatar
  • 1,609
10 votes
3 answers
7k views

How do I shrink the size of a SQL Server log file

I can't figure out how to shrink the size of the databases ldf file. The DBA says I should use backup log dbname with truncate_only And while that looks like it executed correctly in SQL Query ...
Ron Tuffin's user avatar
3 votes
2 answers
2k views

Do we have a ratio between DB data and log file?

OK we all know that a big log file crumbles DB performance. Today we were analyzing a client's server and saw some log files about 3900% bigger than the data file. And that made me curious if is ...
Paulo Santos's user avatar
2 votes
1 answer
3k views

Keeping SQL Express below 4gb?

What would the recommended best practices to keep a SQL Express 2005 database below the 4gb limit? I am willing to export and archive content out of the data tables, but am not sure this will help ...
datatoo's user avatar
  • 351
0 votes
2 answers
2k views

How to reallocate space between two LVM VGs?

I have two disk partitions, say sda1 and sda2, each containing a VG. sda1 -> VG_SYS sda2 -> VG_GUESTS VG_SYS has a number of LV, one for every partition I needed. The problem is that VG_SYS has ...
drAlberT's user avatar
  • 11k
53 votes
6 answers
108k views

How to check progress of DBCC SHRINKFILE?

Is there a way to find out the progress of DBCC SHRINKFILE statement? Here is how I was running it dbcc shrinkfile('main_data', 250000) I am running above statement on both SQL Server 2005 and ...
dance2die's user avatar
  • 2,031