SQL Trasaction Log Question

Dec 14, 2005

How can I read the log file (*.trn) ?

I would like to read all the transactions that were made.

Regards
Manuel Rodrigues

View 1 Replies

Encryption Of Trasaction Logs

Sep 17, 2007

Is it possible to encrypt the transaction log during log shipping? How?

View 4 Replies View Related

Compress Trasaction Logs (LOG SHIPPING )

Jan 29, 2008

hi

If wanted to set up Logshipping between two sqlserver 2005 enterprise edition servers.The transaction log backup is being taken every 2 hours and with approx size of 1GB - 1.5 GB.
Now before the copy job runs,i want to compress the tlog file on primary server,copy it to secondary server and uncompress it on secondary and then apply transaction logs to secondary server.I need the procedure how to do it.Please help out.

Thx in advance

Regards
Arvind

View 3 Replies View Related

SSIS - How Do I Force A Package To Be In One Trasaction?

Sep 12, 2006

Hi,

I want to force a package to work as one transaction so that when one part or container fails, the whole package fails.

Does someone know how to do this?

Thanks,

Ishai.

View 4 Replies View Related