Here you go. Put this in your pipe and smoke it (in your master db and run it, that is).

CREATE Procedure sp_trx_log_shrink (@MaxMinutes INT,
     ...

Quest makes a product that does this and it is absolutely free. Just came out about 3 or 4 weeks ago. I like it.

http://www.quest.com/comparison_suite_for_sql_server/

Here, here! I couldn't agree more. Pleeeeezzze ditch that ad. It freezes up your browser.

Thanks.

Also, if you haven't already, you should set your log autogrow to a certain MB size per growth rather than a percent. If you have a 10 GB database and...

Put this in your master database and then run it from whatever database you want to shrink the log in. See the Example Usage in the header comments.

Be sure to...

"rockmoose" posted an excellet script at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=119721

Nice and short and does the job:

/*=========================================================================

Title: ...

Hi, Steve.

I know I have said this before, but it bears repeating:

The extent to which you can telecommute is proportional (more or less) to the extent to which...

Hi, Steve.

I am a DBA and I only telecommute about once a month. This is all I am allowed by my employer. This used to bug me but I...

Just remember. The extent that you can and do work from home relates more or less directly to the extent you can be outsourced.

I found this to be very helpful. It send you an Alert when any file (log or data file) grows on your SQL Server.

http://www.databasejournal.com/scripts/article.php/1493181

In the long run, you are better off just using common sense. Table names like Customers CustomerShiptoAddresses, Invoices, InvoiceDetails, Orders, OrdersDetails will naturally group (more-or-less) together and for those that...

Check out this link: http://codetempest.com/article.php?story=20050703191510469

It's a stored procedure I run as a job on some of my bigger databases right after such optimizations. It shrinks the log down...

There's the old joke:

Q: How many MS Engineers does it take to change a lightbulb?

A: None. Bill Gates simply declares darkness to be the industry standard, and moves...

I, too, would also like to know the answer to this question. I am in a similar situation. Thanks.

Linche Shea's book "Real World SQL Server Administration with Perl" has a great script called scanForSQLServer.pl. This script has the benefit of showing you BOTH all SQL servers across on...