Post reply

Help!!

  • December 12, 2003 at 8:06 am

    #66230

    Anyone know how add user to access logshippin standby readonly database as report

    feifei liu


    Rachel

  • December 15, 2003 at 4:56 am

    #486135

    Specify that the database be maintained in STANDBY mode rather than NORECOVERY.

    Be careful with read-only connections to the standby database though. Sysadmin logins will block log-shipping (ie. application of transaction logs) and other logins, if active when a transaction log is scheduled to be applied, will be killed.

    Cheers,

    - Mark


    Cheers,
    - Mark

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply