Topic: Shrink SQL Server Transaction Log for all Databases. 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 ...

Using the Transact SQL ALTER DATABASE statement to shrink the transaction log file Open SQL Server Management Studio (SSMS) and click Query Analyzer to open the Query Analyzer window.

For most businesses, the SQL server is the foundation for their ERP solutions that support their business applications with extensive storage and data. These databases contain critical information for ...

So I have a specific database that won't release and shrink its log files. The DB backups are happening successfully, but I still have 4GB of logfiles (and no, this DB does not generate 4GB of log ...

Databases whose data is not required to be changed should be considered to be set as read only.databases can be set to read only mode and back using t-sql and ssms. following are the scripts that can ...

The most recent update to the Windocks platform was the addition of support for SQL Server Reporting Services (SSRS), Microsoft’s report generating system that is used by many organisations to ...

Shrink vCenter Database. Update: For vCenter Server 5.1 and 5.5, see the To truncate all performance data from vCenter Server 5.1 and 5.5 section in Reducing the size of the vCenter Server database ...