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.
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