Yahoo Poland Wyszukiwanie w Internecie

Search results

1. stackoverflow.com › questions › 56628How do you clear the SQL Server transaction log?

   stackoverflow.com › questions › 56628

   11 wrz 2008 · Putting the database in SIMPLE recovery mode will make sure that SQL Server re-uses portions of the log file (essentially phasing out inactive transactions) instead of growing to keep a record of all transactions (like FULL recovery does until you back up the log).

2. www.mssqltips.com › sqlservertip › 4083Remove Unnecessary SQL Server Transaction Log Files

   www.mssqltips.com › sqlservertip › 4083

   • Zapisane w pamięci cache

   18 lis 2015 · Learn how to determine SQL Server Transaction Log usage and how to remove unnecessary SQL Server transaction log files.

3. learn.microsoft.com › en-us › sqlManage transaction log file size - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Zapisane w pamięci cache

   20 sie 2024 · This article covers how to monitor SQL Server transaction log size, shrink the transaction log, add to or enlarge a transaction log file, optimize the tempdb transaction log growth rate, and control the growth of a transaction log file.

4. www.mssqltips.com › sqlservertutorial › 3311How to shrink the transaction log - SQL Server Tips

   www.mssqltips.com › sqlservertutorial › 3311

   • Zapisane w pamięci cache

   25 mar 2014 · To shrink the log in SSMS, right click the database, choose Tasks, Shrink, Files: On the Shrink File window, change the File Type to Log. You can also choose to either release unused space, reorganize pages before releasing unused space, or empty file by migrating the data to other files in the same filegroup: Shrink the log using TSQL.

5. learn.microsoft.com › en-us › sqlDelete Data or Log Files from a Database - SQL Server

   learn.microsoft.com › en-us › sql

   • Zapisane w pamięci cache

   28 lut 2023 · Learn how to delete data or log files in SQL Server by using SQL Server Management Studio or Transact-SQL.

6. serverfault.com › sql-server-transaction-logs-full-how-to-empty-and-delete-themSQL Server Transaction logs full, how to empty and delete them

   serverfault.com › sql-server-transaction-logs-full-how-to-empty-and-delete-them

   After switching to simple mode, use DBCC SHRINKFILE with the EMPTYFILE parameter to shrink the extra log files (might take multiple attempts if the log files are in use, or you might have to wait for active transactions to finish). Then use ALTER DATABASE MODIFY FILE to drop the extra log files.

7. learn.microsoft.com › en-us › sqlThe transaction log - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Zapisane w pamięci cache

   29 lip 2024 · The transaction log supports the following operations: Individual transaction recovery. Recovery of all incomplete transactions when SQL Server is started. Rolling a restored database, file, filegroup, or page forward to the point of failure. Supporting transactional replication.