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 |
|
csaha
Yak Posting Veteran
52 Posts |
 Posted - 2013-04-11 : 17:29:59
|
| Configured log shipping using the following procedure http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/.I have enabled logshipping for 2 databases. The wizard created LSAlert job. Error: Executed as user: NT AUTHORITY\NETWORK SERVICE. The log shipping primary database macinename.AbraHRMS_Live has backup threshold of 60 minutes and has not performed a backup log operation for 78 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14420). The step failed. However the LSBackup job for the database has no error. This is for only primary server database where I see error. The secondary server has no error in the view history and Transaction Log Shipping status. Why do I get error in the primary server? |
|
|
|
|
|
Log shipping