Difference between revisions of "Shink Database And Prevent Transaction Log Growth"

From MS Computech
Jump to: navigation, search
(Created page with "http://stackoverflow.com/questions/480897/how-can-i-manage-sql-server-log-size<br> http://help.fogcreek.com/8686/how-to-shrink-sql-server-transaction-logs<br> <pre> ALTER DATA...")
 
(No difference)

Latest revision as of 21:58, 12 October 2013

http://stackoverflow.com/questions/480897/how-can-i-manage-sql-server-log-size
http://help.fogcreek.com/8686/how-to-shrink-sql-server-transaction-logs

ALTER DATABASE [databasename] SET RECOVERY SIMPLE
Go
DBCC SHRINKFILE (databasename_log, 1)
Go
ALTER DATABASE [databasename] SET RECOVERY FULL
Go
USE [master]
GO
ALTER DATABASE [databaseName] MODIFY FILE ( NAME = N'databasename_Log', SIZE = 512000KB , FILEGROWTH = 0)
GO
Retrieved from "https://msc.siamtools.com/wiki/index.php?title=Shink_Database_And_Prevent_Transaction_Log_Growth&oldid=1154"