Is there a "Truncate_Only" alternative in SQL 2008?

I have no need for these files. so I need an alternative to the "truncate_only" from 2005 to 2008 are there any ideas?  Currently in 2005 I use the backup log with truncate_only and then do a dbcc shrinkfile on it. What can I use in 2008 for the same effect? Thanks for any help I recieve.
simpkinstAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
BACKUP LOG WITH TRUNCATE_ONLY is deprecated in 2008 and the Replacement recommended from BOL below

"The transaction log is automatically truncated when the database is using the simple recovery model. If you must remove the log backup chain from a database, switch to the simple recovery model."

0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
if really you need to do that on a regular basis:change the recovery method of that database from full to simple, so you don't need that at all.
0
All Courses

From novice to tech pro — start learning today.