oops ...

This is done in EM by right click on SQL Error Logs and selecting properties configure.

Recycling SQL Server errorlogs to keep them a managable size may help. The basic command is DBCC ERRORLOG. There are scripts posted that check the size and roll it over...

No. The heart is the only organ non-transplantable in this analogy. Restoration of a user database is like receiving a new kidney, again in this analogy.

Use a SQL Maintenance Plan.

Unless you can get to the console of the server you'll have difficulties. The only other method of remotely upgrading that works well enough (although not entirely painlessly) is to...

Miicrosoft just released a website to help you plan/cost stuff like this:

http://www.microsoft.com/licensing/mpla/programpage.aspx

However, when all is said and done, you'll probably end up on the phone with a MS rep...

You should contact your AD folks because the 'trust' relationship that was established could only be a transitory thing - like for the duration of the domain migration. I'd start...

'autogrow' is a nice feature but not without it's pitfalls as you've seen. I always use 'autogrow' but in a slightly different manner. I alow database data and transaction log portions of...

Could you provide just a bit more information please ? Was the error found in the SQL errorlog or the Windows event log ? Was it issues from EM or...

DBCC DBREINDEX (tablename) only produces the following output:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

As for capturing the output, I use an output file in the...

Modification of recovery modes for the system databases is not recommended nor supported.

I would not write this off as a non-issue. Just because it does not impact/affect your application at present, what is to say that it will not in the future....

One point that was missed ... it concerns recovery ...

Databases are in Recovery mode:

• Master: Full  ---> this should be simple
• Model: Full----->  it is simple by default
• MSDB: Simple
• RSMS:...

We had this problem with the MON OnePoint database some time ago and opened up a case with MS. Here's a script provided by PSS for the problem as a...

Why do you need to monitor database space usage every 10 minutes ? I could see 1 or 2 times a day but every 10 minutes seems a bit on...