If you run through the Maintenance Plan Wizard, which I'm sure a lot of DBAs use, then the default order of tasks is:

Check Database Integrity

Shrink Database

Reorganize Index

Rebuild Index

Update Statistics

Clean Up...

Hi Kirill,

Thanks for the explanation; I am trying to learn German, but I am finding it hard work. Bring back Esperanto 🙂

If I remember correctly, under the German spelling reform...

Could it be, through some hair-brained logic, that the ISA Service tries writing to the database; if the write fails, it assumes the database does not exist and then tries...

Some good information can be found in the TechNet article "Monitoring, Logging, and Reporting Features in ISA Server 2006":

http://technet.microsoft.com/en-us/library/bb794817.aspx

Amazingly, yes, ISA Server does create a new database each day.... I...

The user should give you a clue here - Anonymous login failed. So, there is no point checking your username/passwords; they are not being used. One server is trying to...

Good point Rootman about Council Houses, thanks. Also worth noting that many, many Councils in the UK have "sold off" their stock of Council Houses, either to the people living...

In a full Active Directory environment, you can define the "Logon Hours" for a particular user (found under the [Account] tab in ADUC).

With local logon (no AD) I don't think...

Unfortunately, this is the problem. There is no such thing...

To be fair, it...

Just thought I'd cheer everyone up by saying that I have a company-paid fuel card. I have no idea how expensive my diesel is, because I never pay for it....

'tis true, not all English girls are chavs. If you look hard enough, you'll find a ladette or three. Not sure who is better though.

Sounds like quite a significant problem with that firmware release!

If your current log file is 100MB, but it has been 4GB, you obviously have Auto Shrink enabled (or it occurs...

You have not said how large the Log File currently is; an auto-grow of 50MB may be entirely unsuitable. Also, you may find that internally, the Virtual Log Files are...

It seems strange that an ALTER DATABASE command should be sent to the Witness server. hmm, unless changes are required to the MSDB database...? Or maybe the ALTER is required...