First of all, we have to create a database which needs to be renamed. Select any database in your SQL Server Management System (SSMS). If you don’t have any you can create one by following this ...

This article describes how to shrink a data or log file in ... The primary data file can't be made smaller than the size of the primary file in the `model` database.

Generate T-SQL commands to shrink all SQL Server user database log files or shrink a single database log file back to the original size or as small as possible ...

In such a case, you should not shrink the database as it is merely a waste of time. This refers to using a special code to help your SQL data files take up less space on the disk for storage for ...

What do you do when you can't avoid huge transaction logs in SharePoint and your files are too large? Last month, I wrote about how to avoid having ginormous transaction logs within SharePoint ...