Truncating Transactional Log 1

[earthandfire]

Is there a way using TSQL to truncate the Transaction Log?

 

[SQLDenis]

backup log <name> with TRUNCATE_ONLY
and then you can use
DBCC SHRINKDATABASE or DBCC SHRINKFILE

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[earthandfire]

I spent around an hour looking through BOL and you come back with the perfect answer in three minutes.


Thanks

 

[SQLDenis]

You are welcome and tx for the star

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/