You may use 7-zip as I mentioned in this post.

I use 7-zip to compress files. Here[/url] I had posted on how to use 7 zip in a script.

You can also try Change Data Capture (CDC) feature in SQL Server 2008. More here

Does the query every gets completed or it just keeps running?

Also print the output of @sCmd and run it in command prompt to check if any errors pop up.

The first transaction log cannot be removed. Instead you could move the first log file to the drive which has enough space and then delete the second one.

This article has...

If you add an output file to the job step, that would contain more information regarding the job execution.

Did not check the forum while responding 😉

Even though the "password" option encrypts the backup file, the encryption is not strong enough. You can encrypt the entire database using TDE or use a third party tool to...

I'm sorry. Updated it now.

This article has some good information.

Sagar-636902 (11/16/2010)

I have encountred strange error on sql server 2005.

I have big sql server database, that is the reason i can only keep...

Like Gail mentioned try RESTORE DATABASE .... WITH RECOVERY. If it fails, then you can always RESTORE those databases from the Backups that you have.

If you have SSMS 2008 installed, you can make use of the "Query against Multiple Instances" features. Once you have registered all the instances, you can run any query against...

Hope you have the backups for the two databases involved.

You can also use the TABLOCK hint so that DBCC CHECKDB does not create internal snapshots. More details here[/url]