SQL Server Performance

Need to modify user at Log shipping DR standby ead only mode

Discussion in 'SQL Server 2005 Log Shipping' started by raagi2000, Mar 30, 2010.

  1. raagi2000 New Member

    Hi,
    I want to modify the user permission at the DR database on log shipping with standby
    ead only mode. it does not let me modify because the database is read only mode .
    is there a way around it without disturbing / disabling the log shipping. thanks
  2. MohammedU New Member

    You can't becuase db is standby mode which means you read but not write (modify)...
    Even you disable/stop the log shipping and change what ever you want, it will go back once the log shipping started because destination db is the same as source db...
    Only option would be if the same user exists in source db then change the permissions there and log restore will copy the permissions to destination server.

Share This Page