Have you tried not shrinking the Log file? If so, does the file size stabilize? If the file size stabilizes, you should leave it at that size and not shrink...

Make sure the job is logging to a file and then check the log file.

For the Critical database, you need to be backing up (either T-Log or Full) more often than once a day, I'd suggest anywhere from 15 minute to 4-hour cycle for...

You'll need SP2 to script both Drop and Create's at the same time, and it can only be done from the DB level, not at the object level (as MG...

Greg - exactly.

David - Yes, its the day after the 3rd. Parliament did try to get rid of it a couple of years ago, but they couldn't decide which month...

Apparently, one of our Network Admins was making changes on the box and broke SSRS, once he fixed his errors everything started to work again.

However, if anyone knows the mechanism...

Thanks for the quick response Ben.

Yes, it does. The original installer did backup the encryption key, but he cant find the password for the snk file!! If we can't recover...

Whenever you shrink the log file, the server will grow it again - thats an expensive operation and a definite performance hit, unless you have Fast File Initialization (FFI) set. Add...

Idera's Diagnostic Manager is excellent for this - keeps track of all sorts of good information, and, YES, you can sit and watch it for hours!!!

In 123DBA's script, the line of code "@TruncLog = 'BACKUP LOG ['+ db_name() + '] WITH TRUNCATE_ONLY'" is a sleeper, once you have run this script, you restore path is...

Another point is that you won't get support from MS if you have any problems. In file 'License_EVAL_ENU.txt' (on my box, in folder 'C:\Program Files\Microsoft SQL Server\90\EULA'), it states:

1. ...

Before we all get too worked up about the LDF and MDF sizes, what percentage is actually utilized for the files?

A data recovery tool I've used in the past that works really well is R-Studio (I'm not a salesman - check out their web site if you want details -

Do you have any NOLOCK hints in the views ?

Where does the MSDN document specify max. SSAS instances? The only reference I can find to maximum instances is the "Instances per computer" for "Database Engine Objects", nothing for "Analysis...