Large Log File

I don't have much experience with replicated databases, but I wrote this script that I run on test databases to shrink the logs. Hope it helps. (I use the variables so I don't have to modified it, just change the database which the query is running against)


DECLARE @logname NVARCHAR(50)
DECLARE @name NVARCHAR(50)
SET @name = db_name()
SET @logname = (SELECT name FROM sys.database_files WHERE [file_id] = 2)

DBCC SHRINKFILE(@logname, 1)
BACKUP LOG @name WITH TRUNCATE_ONLY
DBCC SHRINKFILE(@logname, 1)

Submitted via EggHeadCafe - Software Developer Portal of Choice
Scrolling in WPF Toolkit?s Column Chart
http://www.eggheadcafe.com/tutorial...chart.aspx

Hello,

the skript does not function. The Size does not change.

Nighthawk

"William Allison" schrieb im Newsbeitrag
news:

I don't have much experience with replicated databases, but I wrote this
script that I run on test databases to shrink the logs. Hope it helps. (I
use the variables so I don't have to modified it, just change the database
which the query is running against)


DECLARE @logname NVARCHAR(50)
DECLARE @name NVARCHAR(50)
SET @name = db_name()
SET @logname = (SELECT name FROM sys.database_files WHERE [file_id] = 2)

DBCC SHRINKFILE(@logname, 1)
BACKUP LOG @name WITH TRUNCATE_ONLY
DBCC SHRINKFILE(@logname, 1)

Submitted via EggHeadCafe - Software Developer Portal of Choice
Scrolling in WPF Toolkit?s Column Chart
http://www.eggheadcafe.com/tutorial...chart.aspx