Tag Info

New answers tagged

5

Yes, you can, but it is not a good idea unless you are 100% certain the database won't grow again. If it will, then shrinking the file to free up space is like vacuuming while confetti is still falling on your carpet, and you should really read one of the many posts out there on how futile it is to shrink files that are just going to grow again. Nothing is ...


0

The database cannot be made smaller than the minimum size of the database.The minimum size is the size specified when the database was originally created or set by using a file-size-changing operation.Have a look with below query SELECT file_id, name, type_desc, physical_name, size, max_size FROM sys.database_files ; For details about current amount of ...


2

Short answer: Just leave the log file as big as it typically needs to be, and stop worrying about it. Longer answer: First, why do you want to keep shrinking the file? If it's just going to grow again (and keep in mind that shrink and grow operations are expensive, especially for the log), then what did you gain? What did you use all that freed up space ...



Top 50 recent answers are included