Error 5001 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error 5001

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..

Welcome to the forums!
What 2005 sp do you have?

Hi, what is your real issue?
Thank you,
Sandy.

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

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |