SQL Server Performance

Error 5001

Discussion in 'SQL Server 2005 Log Shipping' started by ashiena, Jul 22, 2009.

  1. ashiena New Member

    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..
  2. Luis Martin Moderator

    Welcome to the forums!
    What 2005 sp do you have?
  3. Sandy New Member

    Hi, what is your real issue?
    Thank you,
    Sandy.
  4. ashiena New Member

    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

Share This Page