Tag Info

New answers tagged

2

For starters, there's no issue with shrinking log files, only database files. You don't need to shrink the database - you could simply move the data into a new database that's correctly sized, and then you can get rid of the old files. No fragmentation introduced. I'm pretty sure Paul writes about this. I'd be more concerned about whether the smaller space ...


2

At the risk of making an unpopular statement, I think that shrinking might be a good option for you here. Let me explain... Shrinking a database data file will almost certainly cause fragmentation. This is critical in a production database, where you likely cannot afford the time to defrag the database after the shrink. However, it sounds like you have ...



Top 50 recent answers are included