Post reply

Exclusive Rights Access in Log Shipping

  • March 26, 2004 at 12:48 pm

    #107496

    Hi Everyone,

    Just would like to find out if I've a standby server restoring transaction logs from my production server every 10mins from 2:00am till 10:00pm and besides a standby server, if we use for reporting purpose as well or may be some users are connected to this read-only database. So, while restoring transaction logs will there be a chance that we can get some exclusive rights issue while restoring transaction logs on Standby Server.

    Thanx

    Muneeb.

  • March 26, 2004 at 1:28 pm

    #500736

    Yu have to leave in no recover mode to be able to restore additional TL backups. To be able to use for reporting you have to use WITH RECOVER and bring DB live which in effect kills later TL restores.

  • March 30, 2004 at 3:13 pm

    #501197

    Take a look at this thread for the log shipping QOD.

    In my opinion after put it in standby mode If you set it to dbo only and kill all connections at restore time you'll make it work but it may not be possible to do all that in 10 min intervals though

     HTH

     


    * Noel

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

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