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 · Recover from a full transaction log in a SQL Server database. If your database is in Full Recovery Model and if you are not taking TL backup, then change it to SIMPLE.

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 › 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.

4. dba.stackexchange.com › questions › 300919which log files can be deleted in sql server

   dba.stackexchange.com › questions › 300919

   10 paź 2021 · Transaction Logs allow you to recover your database to any point in time (within the granularity of how often you backup the Transaction Logs). If your Transaction Logs are eating up your disk space, you may not be backing them up frequently enough (or at all, as some people don't realize they need to be backed up).

5. 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.

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).

7. www.sqlshack.com › drop-unwanted-secondary-sql-server-transaction-log-filesDrop unwanted (secondary) SQL Server transaction log files - SQL...

   www.sqlshack.com › drop-unwanted-secondary-sql-server-transaction-log-files

   • Zapisane w pamięci cache

   31 sty 2020 · Drop unwanted (secondary) SQL Server transaction log files. January 31, 2020 by Rajendra Gupta. This article explores the use of multiple SQL Server Transaction Log Files and the process of removing the secondary transaction log file.