Thanks for the info

Hi there,

I receive this error when I test your script with the following parameters

sp_SearchSQLErrorLog @AllLogs = 0, @LogFile = 1, @SearchString1 = 'login', @SearchString2 = 'sa'

RegQueryValueEx() returned error 2, 'The...

Thanks

Same details as the Management Studio properties screen.

Thanks for info.

Date2/21/2009 9:00:01 PM

LogJob History (MaintenancePlan - Reorg - DWAnalytics.Subplan_1)

Step ID1

ServerDATASERV

Job NameMaintenancePlan - Reorg - DWAnalytics.Subplan_1

Step NameSubplan_1

Duration15:21:19

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: DOMAIN\sqladmin. ......

Here is what I found out.

Recovery Model is Full

Database backup is Full ( run at 9 PM)

Transaction Log backups are daily at 12 PM CST

I will work with backup team...

Thank you