@SRosewarne-795472 thx for the suggestion. I will change it on my servers....

hey dale,

I am aware of, nothing to worry its just info msg. i havent tried finding the cause however its not a show stopper.

An INSERT EXEC statement cannot be...

thx for correction mark..

Satnam did you implement this soln?

Thanks Satnam

for CPU, you can create alert in performance monitor

hey ralf. dont do copy paste. open the .sql file in SSMS and then run it will work...

there are lots of third party tools...

thanks OM. I totally agree with you the items you mentioned are core DBA activities. This article just features basic items which need to be monitored on any DB server....

thanks satnam it really work...

can you let me know the port on which SQL service is running?

if it is not running on default port 1433 then you need to create an alias using SQL...

is it SQL Server 2005 Express?

I think the problem is with the backup file, can you try and take a fresh backup manually and then restore it some where?

service pack shud not be a prob since I am also having similar kind of setup in my organisation

how big is the backup file? what time the copy job is scheduled? what time is the restore job scheduled? I think the copy task is not finished.....