Skip to content
Tim Radney
  • Home
  • About
  • Community
  • Presentations
  • Training
  • Need Help?
Tim Radney

Tag: DBCC SHRINKFILE

Msg 3140 – Could Not Adjust the Space Allocation for File

TimRadney | Posted on October 7, 2024 |

I often need to shrink database files. I know, ‘shrinking is bad’, however there are situations where it is very much needed. In my line of work, I come across databases that have been collecting data for year after year after year. One of the things I check for is the largest tables in databases. […]

Read moreMsg 3140 – Could Not Adjust the Space Allocation for File

Filed under: Backups/Recovery

Recent Posts

  • Can You Restore Multiple Differential Backup Files?
  • How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database
  • Hidden Killers of SQL Server Performance
  • How to Protect Against Ransomware as a DBA
  • SQL Server Error 9002 – Full Transaction Log

Categories

  • Azure
  • Backups/Recovery
  • BMC Control-M
  • Pluralsight
  • PowerShell
  • Presentations
  • Query Tidbits
  • SQL Tuning
  • SQLServerPedia Syndication
  • SSIS – How To
  • Tibits
  • Training/Events
  • Uncategorized

Recent Comments

  • Restoring Multiple Differential Backup Files – Curated SQL on Can You Restore Multiple Differential Backup Files?
  • Restoring Databases using Change Data Capture – Curated SQL on How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database
  • The Computer Is Joined to a Cluster on Cannot create Cluster – the computer X is joined to a cluster
  • Mac Horn on #ThankfulThursday
  • #ThankfulThursday - Tim Radney on SQL Saturday #62
© 2025 - Tim Radney | All rights reserved
Powered by Page Builder Framework