Ms SQL Server Log File slimming

Ms SQL Server Log File slimming

Organizations use asp net forums free forum SQL Server 2000
2 years later, the log file is fully loaded with 7 multi-GB hard disks (an oracle test server is also installed on the same server)

If you want to delete LDF offline and then attach it again, the result does not contain LDF and cannot be appended. Find the compression method on the Internet:
1. Set the backup mode of the current database to simple: Right-click the database and select the option tab.
2. Right-click the current database to view the shrinking database in all tasks. Generally, the default settings in the database do not need to be adjusted. Click OK directly.
3. After shrinking the database, we recommend that you set your database attributes to the standard mode. The operation method is the same as the first one, because logs are often an important basis for restoring the database in case of exceptions.