User Tools

Site Tools


public:microsoft_sql_database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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>​
  
public/microsoft_sql_database.txt · Last modified: 2022/11/28 11:06 by kirk.lim

Page Tools