Questions tagged [shrink]
The shrink tag has no usage guidance.
42
questions
0
votes
0
answers
118
views
How to reduce the aws ebs root volume on windows instance
How can we reduce the size of the aws ebs root volume of windows instance. I have the current size of 250 MB, I want to reduce it back to 30 GB since the applications doesn't need 250 GB.
- 1
0
votes
1
answer
597
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 ...
- 151
0
votes
1
answer
774
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):
...
- 53
0
votes
0
answers
121
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
2
votes
0
answers
349
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 ...
- 31
0
votes
0
answers
363
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 ...
- 11
0
votes
0
answers
240
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 ...
- 137
1
vote
1
answer
115
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 ...
- 11
-1
votes
2
answers
858
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 ...
- 11
1
vote
2
answers
292
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 ...
- 316
5
votes
1
answer
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?
google-compute-engine
0
votes
0
answers
786
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 ...
- 19
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 ...
- 21
2
votes
3
answers
2k
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 ...
- 71
2
votes
2
answers
30k
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 ...
- 123
2
votes
0
answers
596
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 ...
- 183
2
votes
1
answer
6k
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, ...
- 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 ...
- 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?
- 2,424
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?
- 157
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. ...
- 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 / ...
- 381
4
votes
2
answers
12k
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 ...
- 167
1
vote
2
answers
714
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
- 1,345
7
votes
2
answers
17k
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 ...
- 173
1
vote
1
answer
52
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 ...
- 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 ...
- 149
6
votes
6
answers
15k
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 ...
- 2,213
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 ...
- 1,424
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
- 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 ...
- 906
12
votes
3
answers
22k
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 ...
- 69.8k
1
vote
2
answers
323
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, ...
- 13
3
votes
3
answers
10k
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 ...
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 ...
3
votes
3
answers
653
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 ...
hani
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 ...
- 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 ...
- 495
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 ...
- 173
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 ...
- 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 ...
- 10.9k
51
votes
6
answers
99k
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 ...
- 2,011