Hi everyone, Enviroment: Server Windows 2003 R2 I was alert by and error message from LSAlert function: Executed as user xxx. User must be in the master database. [SQLState 4200] (Error 5001) How do I remove this error. And how can i checked that my log shipping is working properly.. Thank you in advanced..
its SQL Server 2005 with no SP The real issue is I have received error from my job history of log shipping. Alert Error: 1 Message The job failed. The Job was invoked by Schedule 105 (Log shipping alert job schedule.). The last step to run was step 1 (Log shipping alert job step.). Alert Error: 2 Message Executed as user: SERVERPRIMARYAdministrator. The log shipping secondary database SERVERSECOND.DB has restore threshold of 45 minutes and is out of sync. No restore was performed for 1111 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14421). The step failed ---------------------------------------------------------------------------------- Copy Job: Message : 1 2009-07-08 11:00:08.01 *** Error: The process cannot access the file '\SERVERPRIMARYackupDB_20090708030000.trn' because it is being used by another process.(mscorlib) Message : 2 *** Error: Could not copy log backup file '\SERVERPRIMARYackupDB_20090708030000.trn'. The copy operation will be re-attempted on the next run of the Copy job.(Microsoft.SqlServer.Management.LogShipping) *** ---------------------------------------------------------------------------------- Restore Job: Message 2009-07-08 11:36:22.98 Skipped log backup file. Secondary DB: 'DB', File: '\SERVERSECONDBackupDB_20090706150000.trn' ----------------------------------------------------------------------------------How should I resolve this? Thank you in advanced
