0

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?

Shrink options in SQL Server

Benny Skogberg
  • 157
  • 2
  • 8

2 Answers2

1

If the database contains more than one data file, with the "Shrink Files" options you can choose which file you want to shrink; "Shrink Database" will shrink all of them.

Massimo
  • 70,200
  • 57
  • 200
  • 323
  • Thanks, just what I needed. Does this inclide LOG-files? – Benny Skogberg Nov 07 '12 at 09:59
  • Yes, but they will only be shrunk if there are inactive logs on them, i.e. if the DB is set to simple recovery model or if a transaction log backup has been performed. – Massimo Nov 07 '12 at 10:35
0

Shrink: Basically, if used, this option is to compress your database size or used unusable space.

If you Shrink the database, then all your database will have more space.

If you are Shrink files, then more file space will be available.

Citizen
  • 1,103
  • 1
  • 10
  • 19
Mangesh pansare
  • 1