Two further observations:

1. Backing up the transaction log will only issue a checkpoint if you are using the NO_LOG or TRUNCATE_ONLY clauses (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_241g.asp);

2. Could your problem be related to...

When was the last full database backup?

Try issuing a checkpoint against the database before the next transaction log backup. You might like to schedule a more frequent transaction log...

A simple approach would be to use xp_cmdshell 'copy ...' command to copy the backup file (when the full backup is done) to an alternate location.

My apologies for misunderstanding your problem.

When you said "When I drop the Enumerator combo box on the collections page for a ForEach task", can you explain exactly how you achieve...

SSIS is very different to DTS in many ways that similar names does not quarantee similar functionality.

According to the introductory screen, the wizard is only used to transfer data and...

Try this and see if it works:

1. Right clink anywhere in the 'Toolbox' bar and display a context menu.

2. Select 'Choose Items...' context menu

3. Select the 'SSIS Control Flow Items'...

I am assuming that you are speaking about Transactional Replication, and that you wish to alter the datatype for a column in a replicated table and that the column width...

Have a read of this article: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1174370_tax301336,00.html?track=NL-416&ad=550186&adg=301324&bucket=ETA

What is the currrent setting on your database?

If there is no need to restore the database (in the event of database corruption) to a point in time, then ideally...

I presume you are speaking of the default path where database files are stored? In that case, you can search on 'moving databases' in this website. An easy way is...

Is your linked server for subscribing server(s) using the 'sa' account? If so, you will need to change it there as well!

In any case, its not a good security practice...

Try something like this instead...

update RT

set xxx = LT.xxx

from localdbname.dbo.local_table LT

inner join remoteserver.remotedbname.dbo.remote_table RT

on LT.keyName= RT.keyName

** Note the two aliases used!

You might like to spend some time reading this article entitled 'Physical Database Storage Design' for SQL Server 2005.

http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx

Firstly, no question is considered 'dumb' in this forum - we are all here to learn, and asking questions is the best way to do it!

Secondly, it depends on your...

You can read more about SQL Server 2005 security/encryption in this article:

http://www.databasejournal.com/article.php/1503191

Scroll down to 'SQL Server 2005 Security' and click on 'Encryption - Part 3'. There are some examples...