The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
39 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 ...
1
vote
0answers
69 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 ...
1
vote
1answer
893 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, ...
0
votes
1answer
3k 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 ...
0
votes
1answer
9k 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?
0
votes
2answers
2k 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?
-1
votes
2answers
1k 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. ...
1
vote
2answers
2k 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 / ...
3
votes
1answer
2k 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 ...
1
vote
2answers
149 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
vote
2answers
5k 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 ...
1
vote
1answer
36 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 ...
2
votes
1answer
5k 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 ...
4
votes
2answers
3k 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 ...
1
vote
2answers
1k 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
vote
1answer
938 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
3
votes
3answers
3k 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 ...
2
votes
3answers
4k 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 ...
1
vote
2answers
219 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, ...
3
votes
3answers
895 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
2answers
540 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
3answers
585 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 ...
1
vote
4answers
435 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 ...
10
votes
3answers
4k 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 ...
2
votes
2answers
653 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 ...
2
votes
1answer
1k 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 ...
0
votes
2answers
763 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 ...
11
votes
2answers
14k 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 ...