Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2010-10-08 : 12:02:17
|
| Hi Experts,i've a logshipping setup with monitor server. even though all the jobs (backup, copy and restore) are successful, and databases are in sync completely, the report showing false. please help me in this regard.the sql server agent service is running with an account, which has sysadmin previlleges.OS- Windows server 2008 entsql server - sql server 2008 ent sp1ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-10-08 : 13:48:50
|
| i'm talking about Reports---->standard reports------>transactional log shipping statusArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-10-08 : 14:32:32
|
| error while executing the procedure sp_refresh_log_shipping_monitorOLE DB provider "SQLNCLI10" for linked server "LOGSHIPLINK_ABCD_-475727125" returned message "Communication link failure".Msg 32055, Level 16, State 2, Procedure sp_refresh_log_shipping_monitor, Line 248There was an error configuring the remote monitor server.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-10-11 : 14:34:21
|
| solved....we have not added the users in the other servers.i mean prod user at uat, uat user at prod vice versa.so, monitor server is unable to fetch the dataArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
|
|
Log-shipping report showing false