Pretty much the worst thing you could do to a SQL Server database. In short: It sacrifices performance to gain space.
0
votes
2answers
71 views
Shrink transaction log while transaction in progress
I have a several-GB import into my SQL Server 2005 (Standard Edition) database.
The import is separated into 4 parts, each part in its own transaction.
As you can guess, the transaction log files ...
3
votes
2answers
87 views
DBCC SHRINKFILE works with file_id but not with logical name
I am trying to shrink a database file but am running into errors.
Using the file_id from sys.database_files works, but using the logical file name yields an error.
The logical file name is the same ...
7
votes
4answers
372 views
How should I best handle a rapidly growing database?
I have a database that I need to maintain.
Sadly, the setup and use of that database I can't change, much (thanks to some internal politics).
It's running on SQL Server 2008r2.
Its only been live ...
0
votes
1answer
20 views
Howto shrink an sql-anywhere 12 db?
is there any tool to shrink SQL Anywhere Databases?
With MSSQL/MSSQL Express it was an easy task. Just do it, have a faster DB again which has a size which can be transferred over a slow internet ...
2
votes
4answers
116 views
When should I use the shrink option
I have seen a lot of blogs stating that shrinking is not a good habit as it will reduce the performance of the system. I agree with all those things it will lead to side effects like fragmentation, ...
1
vote
4answers
120 views
Shrinking the log file does not reduce size
I have a database which had mdf size of 350 MB and ldf size 4.9 GB
When i try to shrink the log file it's not shrinking. I know shrinking a database is not good and it should not be done. But still i ...
0
votes
2answers
57 views
Reclaiming space from a large partitioned database
We have a database where one of the business group decided to remove several millions of rows as part of their upgrade process. (we removed for them..).. This database is partitioned based on a date ...
3
votes
2answers
428 views
Shrinking the SYSTEM tablespace in Oracle
Our SYSTEM tablespace grew out of control because of the SYS.AUD$ table.
We have truncated SYS.AUD$ but the datafile is still very big (~30G).
Resize doesn't work because the file contains used data ...
0
votes
1answer
107 views
Is Reorganizing Indexes required after ShrinkDatabase or can I just reogranize index with fragmentation more than 10%?
I am a new DBA to a SQL 2005 production Report server. My predecessor created a Maintenance Plan with 4 tasks: CHECKDB; SHRINKDATABASE (N'DB1',10,TRUNCATEONLY); it seems to be running a REORGANIZE on ...
3
votes
1answer
82 views
Compressions vs shrinking a database
Is compression and shrinking a database in SQL Server same? If I compress a table, will it decrease query performance and DML?
5
votes
3answers
207 views
Everyone warns against shrinking a database, but will it work in my case? 1 GB db with tables removed now 100 MB
Everyone is warning against shrinking a database, e.g.
SQLAuthority
But will it be a valid option in my case? The database was originally more than 1 GB,
but with a table removed from it (moved to ...
0
votes
0answers
29 views
Shrinking SQL Server 2000 database [duplicate]
Possible Duplicate:
Shrinking SQL Server 2000 database
I have become the defacto SQL Server Admin and I have been tasked with moving a production database to a new server. I am trying to ...
2
votes
5answers
1k views
Is it possible to shrink an .MDF file on a drive with low free space?
Is there a way to shrink mdf file of database in SQL Server 2008 without using additional space?
Total space in hard disk is 136 GB, the .MDF file size is 124 GB, and the log file size is 2 GB. I ...
1
vote
1answer
286 views
Use of Shrink after rebuilding Indexes in sql server 2005
I need to create a weekly database plan for my company's databases (5.8Gb), now I want to rebuild the Indexes, and then want to trigger a Shrink operation. Now I know Shrink creates Index ...
4
votes
4answers
455 views
Shrink database is not shrinking as much as expected on a 1.5 TB database.
I'm working in an Enterprise system with a 1.5 terabyte database that is on a single filegroup, with the log in Simple Recovery Mode. Since we have many teams working on different projects in ...
4
votes
1answer
399 views
Mitigate negative effects of shrinking
Closely related to this question from a few weeks ago, but the answers didn't discuss how to do the dirty deed. Here's the situation:
We now 15 GB data in a database, but a logging bug in an ...
12
votes
4answers
6k views
When is it OK to shrink a Database?
I know shrink is the devil: It reverses page order and is responsible for skin cancer, data fragmentation, and global warming. The list goes on... That being said, say I have a 100 GB database and I ...
1
vote
1answer
2k views
TempDB data files don't shrink well on SQL 2008
So ideally you want to pre-size your TempDB data and log files appropriately so that this isn't a concern, but sometimes a rogue developer runs a crazy huge query on a production server during work ...
-1
votes
2answers
295 views
SHRINK FILE works with SA but not as a normal user
My problem is that when I try to shrink the Log it works when I am logged in as SA but when I log in as a "normal" USER it does not shrink the log. (SQL Express 2008r2)
I have tried to find a answer ...
2
votes
1answer
226 views
Shrinking log file
Some of the sql log files (idf) are hugh like 5gb. Found a article (http://extended64.com/blogs/rhoffman/archive/2009/06/11/shrink-sql-server-2008-database-log-file-script.aspx) but not sure why he ...
1
vote
2answers
622 views
SQL Server 2008 - Log file out of control & cant shrink it [duplicate]
Possible Duplicate:
Why Does the Transaction Log Keep Growing or Run Out of Space?
I am having trouble with my database, the log files is currently 250GB in size, I need to shrink this down ...
2
votes
1answer
428 views
Optimising a Database Shrink (in terms of speed and reducing fragmentation)
We have a large database that has had a lot of older data stripped out, leaving primary datafile (all objects are currently in the primary filegroup) of about 80Gb containing a little less than 20Gb ...
5
votes
3answers
2k views
Will the transaction log shrink automagically in SQL Server?
When SQL Server database in a SIMPLE mode, you don't have to care about the transaction log bakcups. But in a SIMPLE mode, the transaction log seems to grow as it does in FULL mode. Does is truncate ...
6
votes
2answers
4k views
SQL Server 2008 log files have minimum sizes, what gives and how do I make them smaller?
Ok, to start with, I screwed up when I created the databases, using a create script roughly like so: (artificial linebreaks and names/paths for wrapping purposes)
CREATE DATABASE [EXAMPLE] ON ...
18
votes
4answers
8k views
How do I shrink all files quickly for all databases?
In SQL Server (2008 in this case) how can I quickly shrink all the files, both log and data, for all databases on an instance? I could go through SSMS and right click each and choose Tasks -> Shrink, ...
2
votes
3answers
241 views
Shrink database after removing extra data
We have a need to fit database in 4G in order to use ms sql express edition.
I started from 7G database, and found a lot of not needed records, and deleted them.
After Shrink database size is 4.6G, ...
