FROM sys.database_files WHERE type_desc = ‘LOG’ Once I have my log file name, I can use the DBCC command to shrink the file. In the following command I try to shrink my log file down to 1GB.

aws-log-shipping-from-onprem-ec2-to-rds-sql-server The Scripts in this repository is t configure logshipping as part of migration or disater recovery from an on-premises sql server or SQL Server on ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

Latest commit History History 46 lines (30 loc) · 2.4 KB main SupportArticles-docs / support / sql / releases / sqlserver-2022 / ...