ah crap, they are gonna kick me out of shadow...

There is also a traceflag/command for using the old carnality estimator

TraceFlag 9481

Enables you to set the query optimizer cardinality estimation model to the SQL Server 2012 (11.x) and earlier versions,...

are you saying this database is on five machines , or that users can log in on all but one machine?  Is this like a  contractor vm that they remote...

• This reply was modified 7 years, 2 months ago by oogibah.
• This reply was modified 7 years, 2 months ago by oogibah.

I might be wrong.. but wouldn't restoring the master database clear this up? if you have a recent backup and you havent done anything else with that database since.. seems...

SELECT  database_name ,
backup_start_date,
is_copy_only,

        MAX(CASE type

              WHEN...

so.. this script will identify objects that use the blob data type...

SELECT o.[name], o.[object_id ], c.[object_id ], c.[name], t.[name]
FROM sys.all_columns c
INNER JOIN sys.all_objects o
ON c.object_id = o.object_id
INNER...

you can also use  the following to test

EXECUTE AS USER = '<user>'

/* Do Something here */

REVERT -- this changes it back to you

So.. just a note to add.. Azure automatically uses TDE on all databases.. and if you leave it on the default of letting azure handle the key it swaps out...

• This reply was modified 7 years, 3 months ago by oogibah.

I did think that was a bit simple for what you were asking .. I've never used maintenance plans before tbh hopefully somebody here is more familiar with them

There is a tool for this called KerberosConfigMgr  ... it makes things easier but keep in mind it isnt perfect.

https://www.microsoft.com/en-us/download/details.aspx?id=39046

Also, there is this command that will let you know if...

Another option that works if your backup path in your sql server settings is correct

DECLARE @BackupDir nvarhcar(255)

EXEC master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE'
, N'Software\Microsoft\MSSQLServer\MSSQLServer'
, N'BackupDirectory'
, @BackUpDir OUTPUT

• This reply was modified 7 years, 3 months ago by oogibah.

Seems like for the most part there is a consensus on Dev should be the same as Prod... Thanks for the input guys.

I feel like there isn't quite enough information here to tell you what is wrong with this..  Are you sure its your dates that are causing no data to appear? ...

Have you attempted to reboot your DR nodes?  Is this something that will cause a ruckus?

There was a previous post here

https://www.sqlservercentral.com/forums/topic/alwayson-unable-to-resume-data-movement

might be some good info in the blog post posted...

Thanks for adding the solution!