Rozdíly

Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.

Odkaz na výstup diff

Obě strany předchozí revize Předchozí verze
windows:mssql [26.01.2015 10:15]
vm
windows:mssql [26.01.2015 10:32]
vm
Řádek 72: Řádek 72:
 What you end up doing is empty the log (CHECKPOINT or BACKUP LOG) and DBCC SHRINKFILE several times, so that SQL Server can move the head of the log to beginning of the file and also so the end of the file becomes unused. Investigate the layout of the log file using DBCC LOGINFO in between. What you end up doing is empty the log (CHECKPOINT or BACKUP LOG) and DBCC SHRINKFILE several times, so that SQL Server can move the head of the log to beginning of the file and also so the end of the file becomes unused. Investigate the layout of the log file using DBCC LOGINFO in between.
  
 +([[http://​www.karaszi.com/​SQLServer/​info_large_transaction_log_file.asp]]).
windows/mssql.txt · Poslední úprava: 26.01.2015 10:32 autor: vm