Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    14

    Unanswered: Log Shipping Question

    Using Log shipping via SQL Ent Edition, do all your users have to be disconnected from the destination server the logs are being pushed to?

    Say, user x is pulling a report from the server, and it takes 2 minutes, after 1 minutes the scedualed log ship needs to take place, will the log ship fail? will the user get kicked off? or will the logs be applied like nothing happend since its read only?

    Anyones that used log shipping alot let me know! Thanks


    Chris

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    I believe because you leave the destination database in recoverable mode, users can not query it - see links for more details

    http://support.microsoft.com/default...b;en-us;314515

    http://www.sql-server-performance.co...g_shipping.asp

    http://www.microsoft.com/technet/pro.../logship1.mspx

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Jan 2004
    Location
    Atlanta
    Posts
    18

    Log Shipping Question

    With Log Shipping, the destination db's are read only. Your users can query them as much as they like - the only stipulation is that they can't have an active connection to a database while it's logs are being restored - I simply have a process that kills any connections to the db before I restore the logs - and that takes care of the issue. Hope this helps.

    Nick DeAngelo

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to the link provided by me to kill those SPIDs before restoring the log.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Thanks for pointing that out Nick, I forgot about that
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •