Snifer: Created page with "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 DATA..."

2013-10-12T14:58:47Z

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

New page

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 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
</pre>

Shink Database And Prevent Transaction Log Growth - Revision history

Snifer: Created page with "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 DATA..."

Shink Database And Prevent Transaction Log Growth - Revision history

Snifer: Created page with "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 DATA..."

Snifer: Created page with "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 DATA..."