Thanks Guys. Just need to fill in the blanks then (should only take me a week or two!!) 🙂

Phil.

Thanks guys.

Phil.

Thanks Damon.

Phil.

Hi.

[Quote]You are missing the Logins[/Quote]

How do I rectify or clear (purge)? Or maybe it is not a problem?

Thanks,

Phil.

You are right, just looked myself! It was not like that when I reviewed it locally.......honest!

I will have another go.

Thanks,

Phil.

Thanks for the response guys. Did you review the attached file?

I will follow the links provided.

Many Thanks,

Phil.

Thanks Scott. I am the only DBA here (well plan to be with another course or 3 under my belt plus some real world experiance!!).

Many Thanks,

Phil.

Hi Guys. The 'Restart' did the trick 🙂

So I now have a single Database Mail Profile + a single Operator. The email notification is quite basic but it tells me...

Hi. Here you go:

[Quote]

Date,Source,Severity,Log ID,Message,Process ID,Mail Item ID,Account ID,Last Modified,Last Modified By,Plan Name,SubPlan Name,Task Name,Duration

12/18/2007 15:36:28,,Unknown,,,,,,,,Clean Up Maintenance Plan History,Subplan_1,,00:00:00

12/18/2007 15:36:28,,Unknown,,,,,,,,,,Clean Up History (SQL-MASTER),00:00:00

12/18/2007 15:35:49,,Information,4,DatabaseMail process is shutting down,4496,,,18/12/2007 15:35:49,FERNAU\SQLSvc,,,,

12/18/2007...

Thanks guys. I have now configured 'SQL Server Agent'. Do I need to define a value for 'Alias Local Host Server'. Reason, I have no value and notification still failing!!...

Thanks guys. The shrink database option was initially set up by the application vendor, although they are not SQL specialists (I do have one coming in January).

I will have to...

One more question! I would like a maintenance plan to delete .bak & Log files older than say 1 week. Is this achieved via 'Clean Up History' 'Maintenance Plan...

Adam many thanks for your efforts. The DB is not OLTP. I will make use of your advice as the project progresses.

Many Thanks,

Phil.

Thanks Adam I will take a look at the recovery mode tomorrow. Pretty sure they were set to Full unless the developers have been having a play!! I will implement...

Thanks for the reply.

Phil.