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 |
|
anoop_mig25
Starting Member
20 Posts |
 Posted - 2015-01-30 : 05:11:30
|
| At one of our client side a wired log shipping issues has come up.while monitoring those two server for log shipping I noticed that although log-shipping report says both server are in sync, report displays information related to both backup and restore options ,but it doesn't shows information related to copy that is "when was last file copied" and last file copy column is showed blank.same is when i execute proc "sp_help_log_shipping_monitor" . I get same result ...When i expand copy job history to analyse its what i found is although job has executed successfully , but in depth reading each steps says that no .trn file was copied .My copy directory is at secondary server itself where .trn files are placed.And from this location itself files are begin restored.sql server and agent on both servers are run by same domain account What could be issue . and what its solutionRegardsAnoop |
|
|
|
|
|
copied file column not displayed in log shipping