Automate shrinking of transaction logs?
-
My database has the FULL recovery model and the Auto Shrink option is checked.
Is there a away to have the transaction logs shrunk automatically?
-
take a look at this discussion and see if it helps you...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=168902
-
Not sure if this is what you are asking ... in FULL recovery mode when you perform a transactional log backup, your transacation log file will be reduced in size since all closed transactions will be removed from the transaction log file after the backup is performed.
Have a good day,Norene Malaney
-
Automatic shrinking of database files is a great way to get really bad windows disk fragmentation and slow server performance. My advice is to turn off autoshrink, and stop running regular shrink jobs. A database file shrink should only be done if you expect a long-term reduction in file size. If the file is likely to grow again within 3 months then it should not be shrunk!
If you have been running for some time shrinking database files then you should look at disk fragmentation and consider running the Windows defrag tool.
You need to look at what space your databases really need and plan to have the right amount of disk space available.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
-
If your database is in FULL recovery mode, you need to be doing full AND log backups.
-SQLBill
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply