Linked Questions

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
3 votes
3 answers
740 views

What steps should I perform to prepare a MDF for distribution as a (mostly) read-only database?

I am on a team that develops a product that uses several SQL Server databases. Some of them are mostly read-only. Tables do not get changed, but some views and stored procedures get changed as a way ...
Justin Dearing's user avatar
1 vote
2 answers
5k views

Reduce space used on C drive

I have installed SQL Server 2008 R2 on my laptop, under 32-bit Windows 7. The SQL Server installation is using approximately 30GB of space on my C: drive. Why is it using so much space, and how can I ...
vijay kumar sharma'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
4 votes
2 answers
2k views

What is the proper way to store a full table of data outside of a database? It needs to be able to be restored as well

I have a large SQL Server 2005 database that hasn't had the best maintenance over the years (I just took it over recently). There are around 100 tables that can be completely removed from the ...
Jamie T's user avatar
  • 45
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
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
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
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
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
0 votes
2 answers
223 views

Best Way to Migrate 100 tables To New Database

I need to migrate 100 out of 150 tables (data and structure) and everything else (sprocs, views etc.) to a new empty SQL Server database. I have been using the Import/Export wizard and it has been ...
user3099771's user avatar
0 votes
1 answer
365 views

How to restore SQL Server database to a specific day? [closed]

Suppose I have an SQL Server 2008 which is installed on windows 2008. There is a db MyDb under the instance. MyDb is have full backup every night. Because of storage space on hard driver, only 7 days ...
KentZhou's user avatar
  • 145
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
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

15 30 50 per page
1
2