February 26, 2014 at 10:39 pm
Hi,
Log shipping status report not opens its takes very long time (more than 45 min), its says "Please wait while data for the report is retrieved from the server" in primary server after that all jobs getting alert.
In secondary server report open with in 2 sec and all jobs getting alert.
Please provide the solution its very urgent.
Pradeep
February 26, 2014 at 11:46 pm
If it is opening slow, do you have a very large job history retention?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 26, 2014 at 11:52 pm
history retention is 3 days only, everything is working fine before domain migration.
Why becuase our primary and seconday servers is running under the same domain account but monitor server running is different domain account.
Is it having any impact of domain migration?
Pradeep
February 27, 2014 at 12:01 am
Yes, the domain migration could be impacting it.
You should have your AD guys verify the trust relationships and ensure the accounts from both domains have adequate permissions to each domain and to each server in your logshipping setup.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 27, 2014 at 12:16 am
Thanks.
Pradeep
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply