Home Forums SQL Server 2005 SS2K5 Replication sql2008 push replication RE: sql2008 push replication
Michael Oberhardt
Ten Centuries
Points: 1109
More actions
January 8, 2014 at 5:34 pm
#1678637
For 2005, with recovery mode in simple, you should be able to just run
BACKUP LOG db_name WITH TRUNCATE_ONLY
DBCC SHRINKFILE (LogicalFileName, Size)