Hmm, Hours or Minutes are the only frequency options for a job schedule!!!

can you post details of the backup, copy and restore...

you're welcome!

I'm not entirely sure it's possible to find how long the restore took, if i find it I'll let you know

You're welcome

It can and will, see Paul Randall's article at the following link

The Backup Exec SQL agent is especially useful for customers who wish to enable backup management within one product and not have to go configuring multiple jobs or plans, etc....

System Centre Operations Manager?

I concur, Michelle's script is awesome.

i haven't mentioned Exchange server, i pointed the OP to Books Online to gain information on how to enable and configure Database Mail on a SQL Server instance 😉

don't give out SA privileges 😀

I ask them to explain why they need SA, when they can't give a valid reason i use that as my push back 😉

It's...

execute the following from the monitor instance and post the results

Substitute the values below with your servername and database name

exec master..sp_help_log_shipping_monitor_primary

@primary_server = 'primary_server',

@primary_database = 'primary_database'

check Books Online for configuring a database mail profile 😉

TST1 (7/4/2011)

---

Hi,

I'm looking for a script that will tell me who did the restore and how long it took. I've got a script which gives me file details but...

KKK17 (6/30/2011)

---

Hi All,

Thanks a lot for the replies..

I have found a script which creates logins on the secondary server using linked server. This script runs on secondary server and can...

easier for pure reporting is log shipping. Easy to setup and maintain but read only (which is all your reports should need)

you might also want to configure a mail profile for database mail so that the stored procedure SP_NOTIFY_OPERATOR doesn't fail too! 😉