The log backup files grows, not the ldf files.

Yes, I appending the log backups into a single file. 

It seems that the log backup job keeps backing up starting from the last...

the log backup runs every 30 minutes from 6am to 10pm.  The recovery mode is full.  The database is setup with default: no replication, no mirroring.

SQL build: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)   Apr 14 2006 01:12:25   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)...

Truncate is not logged.  I was just afraid it would break the LSN in the transaction log causing log restore failed.  Even I did a test and was able...

There is only one thing different: the way we update data.  We often need to update lookup tables.  With SQL 2000 the data import-export tool let us drop and recreate the...

nope.  All are default.

Mohammed,

I used a 3KB file to test the job so its size is not a problem.  I am able to run EXEC xp_cmdshell

I finally see the remote servers.  All I need to do is using public IP address of the server, not the alias name of the server.  How dump I was but...

Tom,

The remote connections is already enabled.  I changed the startup acct for SSIS to local admin acct;  it didn't help.

At the remote location there are 2 servers in a workgroup.  I...

You are correct.  Actually this is just a sample I made up to represent a complicated table with data collected from reading devices and change every minutes.  Thanks.

I came up with this one:

select * from #Table

where id not in

     (select min(id) from #Table

       group by Owner, PropertyID)

Thanks anyway.

Great advice!

Thanks.

please ingore this post.  I made a mistake selecting wrong schema db_owner instead of dbo. 

Thanks.  It works.

thanks guys.