Post reply

does SQL 2005 allow log shipping between 2 instances

  • June 27, 2007 at 7:46 am

    #715535

    hi,

       are you sure all the tran logs are available because if any of those is missing,maybe someone would have deleted by mistake in that case also the restore job would fail.for eg.)if any of the current tran log very recently copied from primary would have been deleted accidentally in that case all the subsequent logs cant be restored......just check the transaction logs are same in both source and destination......

    [font="Verdana"]- Deepak[/font]

  • June 27, 2007 at 9:46 am

    #715574

    Hullo Phil & Deepak!

    Thanks for being such a sweetie and still patiently replying to my post.

    I finally stop tearing my hair out this afternoon after i chanced upon this guy blog.Check out this link.

    http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx

    Turns out my only problem was,my SQL Browser was disabled.So i enable it by going to the Administrative Tools>Services.

    The SQL Browser was needed to allow the instances to 'talk' to each other.

    Dunno if i mentioned this on my prev post,but i also have to give the log on account of what the SQL service and Agent is using  the modify read and write permission on the drive and folder that will be used to store the transaction log.

    Ah..hakz...just because of one service disabled,i learnt alot about other things as well through out this past week.

    Anyway i also found out how to view errors and other related matters to log shipping in SQL 2005.

    All i needed to do was to open the system database - msdb and view the tables they have on log shipping.

    From the table names,you can just do a simple select statements on the table and run a query and it will give you all the info you need.

    Now i shall update the other post entitled  'Log Shipping logs never get shipped to Secondary database' with the latest info i've learnt like how to bypass network security to enable two servers on different workgroup access each other and what ports should be opened to allow SQL Agent to do their work.

    We need more people like Phil and Deepak around to make the world goes round...:wownce again Thank You for giving me hope for a brighter day by replying to my posts.

    ~My 'SHIP' finally reached its Destination Port! Next Stop Database Mirroring!~

    Axlin

     

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

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