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 · Stop SQL services; Rename the log file; Start the service (The system will create a new log file.) Delete or move the renamed log file.

2. 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 · To delete data or log files from a database. In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance. Expand Databases, right-click the database from which to delete the file, and then click Properties. Select the Files page.

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

4. www.isunshare.com › sql-server › how-to-empty-and-delete-sql-server-log-fileHow to Empty and Delete SQL Server Log File - iSunshare

   www.isunshare.com › sql-server › how-to-empty-and-delete-sql-server-log-file

   • Zapisane w pamięci cache

   4 sty 2024 · Whether SQL Server log file has occupied a lot of space on server? This passage will tell you how to shrink even delete log file to save or free space.

5. dba.stackexchange.com › questions › 13757backup - Safely deleting a SQL Server log file (.LDF) - Database...

   dba.stackexchange.com › questions › 13757

   The SQL Server 2008 Internals Book (pp 175-177) implies that detaching the database, deleting the log file and reattaching the mdf file ought to be quite safe as it says. Detaching a database ensures that no incomplete transactions are in the database and that there are no dirty pages for this database in memory.

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

   dba.stackexchange.com › questions › 300919

   10 paź 2021 · Is it safe to delete SQL Server dump files and error log files? It looks like files in multiple folders can be deleted. Following are the paths where the log and dump f...

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.