Best practice to shrink a database

For a SQL Express db, I wouldn't worry about using shrink.

You can use SHRINKDB, but you cannot leave a minimum amount of space in the file using that method (afaik: I'm a professional DBA, so I don't use SHRINKDB. For more advanced dbs, it's better to shrink only the specific file(s) that need it.).

1 Like