This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
public:microsoft_sql_database [2019/08/19 15:29] ronnie.chan |
public:microsoft_sql_database [2019/08/19 15:33] ronnie.chan [VSS Mode] |
||
---|---|---|---|
Line 166: | Line 166: | ||
To prevent this from occurring, you can modify the recovery model of database selected for backup to Simple. | To prevent this from occurring, you can modify the recovery model of database selected for backup to Simple. | ||
- | Alternatively, to truncate the transaction log files, you can perform a transaction log backup manually, or create an additional MS SQL database backup set in ODBC backup mode to perform a transaction log backup. | + | Alternatively, to [[#truncating_transaction_log|truncate the transaction log files]], you can perform a transaction log backup manually, or create an additional MS SQL database backup set in ODBC backup mode to perform a transaction log backup. |
</WRAP> | </WRAP> | ||
Line 377: | Line 377: | ||
</WRAP> | </WRAP> | ||
- | For MS SQL Server setups where you cannot modify the recovery model of the database, please refer to here for details on how to truncate transaction log (e.g. perform a transaction log backup manually). | + | For MS SQL Server setups where you cannot modify the recovery model of the database, please refer to [[#truncating_transaction_log|here]] for details on how to truncate transaction log (e.g. perform a transaction log backup manually). |
</WRAP> | </WRAP> | ||