SQL Server Performance

RE:Log Shipping challenges

Discussion in 'SQL Server 2005 Log Shipping' started by tkatende, Jan 21, 2010.

  1. tkatende New Member

    Hello there, am new to sql server 2005 and i would like to know if it's possible to do log shipping on one computer with two instances having one instance as a primary server and the other as a secondary server. If it's possible how is it done?
    Tx
    Timothy.
  2. preethi Member

    Welcome to forums.
    First of all it si possible to log ship between two instances.
    Please refer http://msdn.microsoft.com/en-us/library/ms190016(SQL.90).aspx for more details.
    I just mention a couple of things.
    • Make sure your primary database is in full or bulk-logged mode
    • Go to database properties and select Log shipping in Management Studio.
    • When specifying the endpoint give a different port number for the secondary server.
    • Backup the primary database and restore in secondary server. You may have to restore the tail log backup too (some times)
    Things should work smoothly,
    Hope this helps

Share This Page