This sounds a lot more complicated than using something like xp_crypt or other tool to encrypt columns. What's the benefit ?

Take more frequent t-log backups and run a server side trace. See if you can match up activity in the trace with the same time that you have large t-log...

Scenario 1) Why do you want them on the same drive ?

To move a file, detach the database, move the file, attach the database specifying the new file location. The...

How frequent are your full backups ?

How frequent are your transaction log backups ?

" ... how can we move a ldf file to go to the mdf file ..."

Do...

Also, keep in mind that if you don't include the hours & minutes, SQL assumes 00:00:00. That can be important sometimes. If you were searching for <= instead of...

It's annoying and not practical to dig up an old thread, especially one with 4 pages, and then put your own problem at the end. I started to rant more,...

If you look at the sizes of your t-logs since the last full, would that help give you an idea of the size of a new diff ? Not...

When I have this problem, I "cheat" if I can.

I create a temp table, with a unique index on the column containing duplicates.

Then set "ignore duplicates" on the index.

Then...

When I have this problem, I "cheat" if I can.

I create a temp table, with a unique index on the column containing duplicates.

Then set "ignore duplicates" on the index.

Then...

You could omit select queries since they don't cause log growth.

Do you have ETL processes that are importing or updating large amounts of data ?

Thanks for the replies.

I am breaking the jobs into batches ... very tedious :crazy:

Transactional replication popped into my mind too. But you will need to have primary keys on the tables. If you don't have primary keys, then you have to do snapshot...

This is the one I used. A couple of clicks and they were all done !!

Thanks for the link. Is there any way to create a function within SQL ? I don't know anything about C#.

Will BlowFish or TwoFish work with image data ?? I downloaded the latest SQL toolkit and Tried running TwoFish after modifying it to handle image data converted to varbinary(max)....