I added 2 attachments, ( I couldn't figure out how to paste them in my post)

Pic1 is from the secondary server showing the replica states...it shows the same server name...

They all return SYNCHRONOUS_COMMIT

I got this to work be deleting the login under the MASTER database and re-adding making sure to add his schema

Yes it gives the error that I show in my original message.

This used to work, but something happened and now it doesn't.

No, and I wasn't going in that direction since it runs very quickly via SSMS...

The SP on SQLA Pulls data from SQLB into a production database using both tables and databases on both servers.

We are running SQL2008 R2

EXECUTE master..sqlbackup '-SQL "RESTORE LOG [XXX] FROM DISK = ''D:\xxx\TransactionLogs\*.sqb'' WITH PASSWORD = ''xxxx'', MOVETO = ''D:\xxx\TransactionLogs\Processed'', STANDBY = ''D:\XXX.undo'', DISCONNECT_EXISTING, ORPHAN_CHECK"', @exitcode OUTPUT, @sqlerrorcode OUTPUT

Thanks for all your comments and recommendations. You gave me a good starting point.

I have been using VSS for SQL control, but it is a pain and I am sure...

There are no begin and end transactions...it is simply

An INSERT into an empty table via SELECT * from a_view.

The view is probably 4 million rows.

I am not actually responsible...

I am not actually responsible for the code of the job, just the server it self.

The job does an INSERT into an empty table via SELECT * from a_view.

The view...

I am not the one who wrote the job, but i am the one who is charge of the server and the backups and logs...I never thought about BULK INSERT....

I found the problem.

Within the rsreportserver.config file located in c:\program files\microsoft sql server\mssql.3\reporting services\reportserver

there is a line that looks like this:

<UrlRoot>http://ccxxspdb014/reportserver$cc_iet</UrlRoot&gt;

It should have ccxxspdb020 instead of 014....wrong server...

go to http://www.sqlservercentral.com/articles/ssrs/69257

at the bottom of the article is a zip file you can download that has the reports...I use it these reports alot....

The CInt(20) worked. I also took off the 2nd parameter on the Count function. I thought the 2nd parameter was for grouping, but I didn't really need it anyway as...

you could use "dateadd" in your query statement.

You could do "union" to combine the select of the 3 different time periods and "dateadd" on the date field within your where...