As far as I know it's not possible to enroll anything other than 2008 R2 into UCP. I found the following on the MS website.

"Before you create a UCP,...

Are you talking about MSDE? Yes, you can manage MSDE instances from your desktop. I have about 20 of them I manage. You just have to register them in EM....

In order to get a smaller transaction log for your restore you will have to shrink the original transaction log and do another backup. During a restore transaction logs are created exactly...

Thanks for the responses. It turns out the mail profile wasn't installed under the domain service account for SQL Server.

Cheers.

CPU utilization doesn't exist in the SQL Server Performance counters, so I don't think you can do it with the SQL Agent alerts.

We currently manage high CPU utilization issues through...

The only way to have fail-over capability would be to build a cluster with either microsoft or veritas clustering. However, there are many other ways to have redundancy in SQL...

If you lost your system completely, then you will only be able to recover to your last transaction log backup, which in your case would be 4pm.

No. It should show status as Rollback. That is the way I have seen it before.

Point in time recovery allows you to restore a database to a certain date and time.

Let's say you had a someone delete a table on Monday @ 9am. With Point-in-time...

Have you looked under Current Activity/Process Info in EM? I would think you should see it in the status column under one of the system processes.

Good point Rudy. You need to make sure to backup the transaction logs more often in order to keep the log file size down.

Thanks for the response. That is the way I am currently working around the problem. However, it doesn't seem to work in all instances. What I mean is, when a person...

I have never heard of anyone connecting to SQL Server through Telnet. However, I could be wrong.

You might try adjusting the indexes on the tables that are being deadlocked. I have had issues with this in the past, and have had some success in solving it...

Yes. You need to truncate the log, then use the dbcc shrinkfile command to reduce the logfile size.