This code is used to add a new log file to the database using the alter database command. Method 2-Recover Database from an Existing Backup. If you fail to rebuild the corrupted Log files, then you ...

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.