I have a job that runs every 15 minutes that checks a table in a given database for a date/time in the future. If it finds a future date/time,...

I know this topic is old but did you ever find an answer for this? I have the same situation and I was trying to suppress those messages in...

Sorry about that. Post it when you figure it out.

FYI, I'm on SQL 2012. Try making a change in one of the fields and see if the View TSQL button becomes available.

In Management Studio, under Management -> Maintenance Plans, open your maintenance plan. Double click or Edit the task that you want to view. At the bottom of the...

Understood. Thanks for the help.

-tim

Thanks.

I used the Maintenance Plans wizard to create the backup jobs and I see in there that it contains the following for each db:

DECLARE @preferredReplica int

SET @preferredReplica = (SELECT [master].sys.fn_hadr_backup_is_preferred_replica('TestDB'))

IF...

We also started getting this error immediately after installing SP2 on our 2008 R2 instance.

No

Thanks GilaMonster.

Reading previous posts, I had a feeling that you were going to say that. 🙂

I figured out my problem. I had a prior backup set in the .bak and .trn files and that was apparently confusing it (or more likely me). I...

Apparently that is the problem. We have Standard, not Enterprise. Thanks Steve.