Mac

August 7, 2007

The MS SQL Server transaction log

Filed under: Database — mac @ 9:20 am

The transaction log grows, grows, grows and quite often fills up.

I know two ways of shrinking it:

  • With backup:

backup log netmeter(db_name) to disk=’specify the filename’

  • Without backup:

backup log netmeter with truncate_only

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google]

August 1, 2007

WORM - aka how to write things in stone

Filed under: Uncategorized — mac @ 9:21 am

Powered by WordPress