If all you want is to shrink them try:

BACKUP LOG dbname WITH TRUNCATE_ONLY

DBCC SHRINKFILE(dbname_Log, truncateonly)

Do you really want to delete them or just shrink them back to as close to original size as possible?

All I did was pick an answer, then got the pop up screen, read the question and then choose the correct answer!!!

Funny, I just asked that same question to the other DBA's here they told me NO, there is not an EM option to do this.

Thanks, Chris. I was having a hard time finding anything on this. I have a programmer here who used to code Oracle and asked if there was something similar. I...

We use a variation of #2. We backup to disk, then copy to disk on another server. Then these are both backed up to tape. The reason we copy to...

Have you run a query plan to see if it is natural for this to use that index?

Very nicely put! After working with you, I would expect nothing less, for your advice and explanations have always been on the money!!!!

This is a very good way to go. I would also add that you might want to do the same things with views!!!

Thanks for the great article. I think you may have just given me motivation to get back on the 'CERT' track!

I used DBArtisan (mainly because we had Oracle, Sybase and SQL Server). Liked it alot!

The best part of this article is the 'I TOLD YOU SO!!!!'. This has happened so many times from a DBA's perspective, whether it is a potential security risk or...

Good article. Gives us all a way to accomplish a task that will work best in some situations!