Search results
11 wrz 2008 · ANY time you move data around in a SQL Server database, you'll require logging - bloating the log file. To decrease log size, either set the DB to Simple Recovery OR (if you care/need logged data - and you almost always do in production) backup the log.
28 lut 2023 · Learn how to delete data or log files in SQL Server by using SQL Server Management Studio or Transact-SQL.
16 lut 2010 · You can change the database to the Simple recovery model. The default of Full recovery model will only reduce the transaction logs after a full DB backup has been taken. If you have SQL Server 2000, you can also use the BACKUP LOG log_name WITH NO_LOG command which will mostly empty the log ready for shrinking. Share.
22 kwi 2009 · SQL Server can shrink a database as part of a maintenance routine. But in some circumstances, it may be necessary to truncate the transaction log and use the DBCC SHRINKFILE statement before the log file is shrunk.
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:
29 lip 2024 · Every SQL Server database has a transaction log that records all transactions and the database modifications made by each transaction. The transaction log is a critical component of the database. If there's a system failure, you need that log to bring your database back to a consistent state. Warning.
19 sie 2010 · There are several parameters this stored procedure takes: @db_name - database name that you want to shrink log file. @target_size_mb - the desired size of the tranascaion log. @backup_location - location of the backup files. @backup_file_name - name for the backup files.
