Post reply

log shipping

  • January 25, 2011 at 1:00 am

    #230835

    Hi All,

    I want to test log shipping on my test machine.

    can you please assist me with the following questions.

    1) is it posible for me to have one instance on SQL server 2008 and other one on SQL server 2005 ?

    2) considering both instances on sql server 2008...

    Is it possible for me to have other datbases too ??

    I mean if i am going for 1 db for log shiping, do i use other databases

    for normal operation ?? is there any problem to use other databases...

    thanks

  • January 25, 2011 at 1:15 am

    #1277646

    fawwad (1/25/2011)

    1) is it posible for me to have one instance on SQL server 2008 and other one on SQL server 2005 ?

    2) considering both instances on sql server 2008...

    Is it possible for me to have other datbases too ??

    I mean if i am going for 1 db for log shiping, do i use other databases

    for normal operation ?? is there any problem to use other databases...

    1. All of our developers here have both 2005 and 2008 installed, as well as several of our test servers. It isn't a problem.

    2. I'm not sure I understand this question correctly. The database that you are log shipping from is fully useable, and it does not affect any other databases on that server. If I recall corrrectly the database that you are log shipping to will be in Recovery mode.

    BrainDonor.

    Steve Hall
    Linkedin
    Blog Site

  • January 25, 2011 at 1:22 am

    #1277649

    It should be in Recovery mode.

    Satnam

  • January 25, 2011 at 1:26 am

    #1277653

    The log shipping destination will be RESTORING (or STANDBY), not RECOVERING.

    The primary can be SQL 2005 and the secondary SQL 2008, but not the other way around. They should be the same version

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 25, 2011 at 1:30 am

    #1277654

    1) is it posible for me to have one instance on SQL server 2008 and other one on SQL server 2005 ?

    yes it will work if primary on 2005 and secondary on 2008. Also make sure the database are getting restored with norecovery and not with standby(as it will not work)

    2) considering both instances on sql server 2008...

    Is it possible for me to have other datbases too ??

    I mean if i am going for 1 db for log shiping, do i use other databases

    for normal operation ?? is there any problem to use other databases...

    yes you can configure as many user database as u can. But need to configure for every database individually.

    Also if both instance have same platform then to use secondary database as read only, you have to restore the database with standby.

    PS :- Please ignore if I answered late or you already found the answer.

    ----------
    Ashish

  • January 25, 2011 at 1:36 am

    #1277655

    GilaMonster (1/25/2011)

    The log shipping destination will be RESTORING (or STANDBY), not RECOVERING.

    Thanks Gail, obvious once you point it out. A case of being almost certain but too quick (or idle) to check for certain.

    BrainDonor.

    Steve Hall
    Linkedin
    Blog Site

Viewing 6 posts - 1 through 5 (of 5 total)

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