Linked Questions

0 votes
2 answers
123 views

What's the difference between "shrink" file vs simply reducing the initial size?

I'm totally new in DB Administration. So i got confused about the "file shrink" functionality offered on SQL Server Management Studio (SMSS) or via T-SQL. Why I would I need to use that &...
Plain_Dude_Sleeping_Alone's user avatar
-2 votes
1 answer
109 views

Shrink of a big databases ? SQL Server [duplicate]

In this moment I have a very big database (almost 4 TB) and wanna shrink data files for a future migration Unused space : almost 3000 GB I have in mind shrink data files day per day with low amount of ...
SakZepelin's user avatar
0 votes
0 answers
53 views

Is a SQL Server DB worth shrinking? [duplicate]

I purged about 100 GB on 200 GB SQL Server v11 DB. The MDF file still show about 200 GB in the file explorer. Everything looks fine, first tests shows 50% time treatments increase and the backup's ...
Meoffrey's user avatar
1 vote
1 answer
737 views

Shrinking mdf files - SQL Server 2012

I am in need to shrink a data file in SQL Server 2012. I am using shrink files option in tasks of the database and am using "Reorganize pages before releasing unused space" option. SQL Server says ...
Jack's user avatar
  • 59
0 votes
1 answer
108 views

Shrinking bigger databases [duplicate]

Hello masters of MS SQL I have a kind of a problem on my hands. We have quite big DB (5TB) and we've just "enabled" some software archiving which means that most of the data will migrate to other DB'...
Robert's user avatar
  • 1
4 votes
3 answers
6k views

Releasing free space in mdf file to OS [duplicate]

We have a 120GB database. There was table with 60GB of data which is useless and we have truncated it. Now database size is 120GB with free space 60GB. The database will not grow up to 60GB in at ...
Pரதீப்'s user avatar
0 votes
1 answer
99 views

Unable to shrink files

I am kind of new to SQL Server. I am trying to shrink my MDF files, however I am unable to do it. There is no error message. Any idea why this is the case ?
Ijaz's user avatar
  • 1
0 votes
2 answers
5k views

Are there any disadvantages to shrinking a database? [duplicate]

My production server's database grows unexpectedly and almost I am going to create a job for shrinking the database which runs once in a month. Is it a good idea? The backups was failed and the time ...
Parassharma1990's user avatar
5 votes
3 answers
289 views

Shrinking database which is not having any insert/update

We have a process of archiving wherein we take the backup of current database and restore it as xxx archive database. Now this database contains previous data and will not have any insert/update/...
azim's user avatar
  • 177
0 votes
2 answers
33k views

Reduce MDF file size [duplicate]

I am working with a 500 GB SQL Server database. I need to reduce the size of the database data file after removing a large amount (50%) of the data. I tried re indexing, it's good the database has de-...
kannadhasan G's user avatar
1 vote
1 answer
1k views

How to restore a database, ignoring the free space within each file?

Using the following script I get all the disk space used by each file in my database: ;with radhe as ( SELECT DatabaseName = 'my Database', --DB_NAME(), a.FILEID, [FILE_SIZE_GB] = CONVERT(...
Marcello Miorelli's user avatar
2 votes
2 answers
4k views

Should I shrink this SQL Server data file?

I have read many articles describing how shrinking data files causes terrible things to happen floods, famine, fragmentation, and general mayhem. Here is the cliff notes of my situation: SSAS ...
DMikulaSr's user avatar
0 votes
1 answer
84 views

One time database shrink catch-22 solution?

I am developing a plan for SQL Server 2012 EE to properly downsize and type (nchar to char types) some needlessly Unicode nvarchar(max) fields and would like to optimize the database size as part of ...
Dave's user avatar
  • 175
5 votes
2 answers
338 views

How can I efficiently downsize some Unicode fields?

We have a SQL Server 2012 Enterprise live transactional database that is now growing over 1G per month and is becoming a size problem for us. It is currently at 23G. Character type fields are all ...
Dave's user avatar
  • 175
3 votes
1 answer
397 views

Ways to Reduce Database Size and possibly improve performace. Untouched enviroment

I am new to an environment. The databases are virtually untouched by a seasoned DBA. I am looking for ways to reduce DB size and possibly improve performance. Unfortunately, I only have Web edition ...
whereisike's user avatar

15 30 50 per page